Unfortunately, you encountered a difficult problem encountered. Unfortunately, you must be edgy. People can encounter this error is not an ordinary person. So you must not a mortal, you are special.
Oh, and you do not joke. Now analyze the problem.
oracle support his db_block_size file size and the number and db_block decision. Before the oracle 9i, oracle maximum number of db_block only 2 of the 22 th power, but oracle default template we built a database instance db_block_size is 8K. So oracle 9i supports single file before the default size is 32GB. Although there is no such restriction oracle 11g, but it is so much the default capacity. So I said before if you encounter this problem to show that you are not most people, you create a single file more than 32GB of table space.
So how to solve this problem, I am here to provide three reference program, you use choose the right one for you, Oh:
A) Do not create a single file over 32GB table space
If you create a table space more than 32GB, please put this table space is stored as multiple data files, each no larger than 32GB. In this way, you can successfully create the table space.
B) expand the db_block_size
According to the oracle of the algorithm, we can easily think of this solution. A constant number, but you can change db_block_size (db_block_size the maximum size of 32KB). If db_block_size expanded to 32KB (32-bit systems like 16KB, my Red Hat Enterprise Linux operating system to create the block_size 32KB failure.), Then our system to support a single data file can be maximum 128GB.
This program sounds like a very charming, but not actually the case. Because you want to modify db_block_size not very easy. Because of this, when you create an instance db_block_size must be specified. And can not be modified by a simple parameter to specify db_block_size. Create an instance of a larger database of db_block_size I will speak later.
C) create bigfile tablespace
The introduction of a bigfile in oracle11g table space, he takes full advantage of 64-bit CPU's addressing capabilities to enable oracle to manage data files total to 8EB. Single data file size to 128TB, even if the default 8K of db_block_size reached 32TB.
Create bigfile tablespace using sql statement is simple.
create bigfile tablespace ...
Behind the statements and general statements the same.
Note that using bigfile table space, he can only support a data file. That is the maximum file size is the maximum size of table space, you can not file by adding data to expand the size of table space. So oracle, if you file no space left, you still do not use bigfile table space, this table space you do not have room for expansion, and Oh.
oracle also tell you, I suggest you use lvm or other software management disk, so you can dynamically expand the space. Oh, first mentioned here, if there do not understand, please let me know.
There are also instructions.