RE: problem with creating non default blocksize tablespace
- From: Freeman Robert - IL <FREEMANR@xxxxxxxx>
- To: 'Darrell Landrum ' <darrell@xxxxxxxxxxx>, "'oracle-l@xxxxxxxxxxxxx '" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 14 Sep 2004 12:20:11 -0500
The max size of any datafile is a factor of the block size of the tablespace
associated with that datafile. Right off hand I don't know what the
restricton for 2k block size would be, but I'm fairly certain that it's much
smaller than 20GB.
Robert
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
To: fuadar@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Sent: 9/14/2004 12:08 PM
Subject: RE: problem with creating non default blocksize tablespace
I was trying to check the docs, but the 9i ones seem to be unavailable
at
otn right now.
However, I'd look toward reducing the size of datafile
/dev/rvd_bptrnext8
from the almost 20 GB that is specified.
From that error message, it appears there would be a file size limit of
7.99
GB.
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Fuad Arshad
Sent: Tuesday, September 14, 2004 11:34 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: problem with creating non default blocksize tablespace
I've already set the db_2k_cache_size
is there a limitation for setting this up.
what do i need to check .
what am i doing wrong.
couldnt find anything on metalink nor the docs.
SQL> CREATE TABLESPACE D_PATLOB DATAFILE
'/dev/rvd_bptrnext8' SIZE 20010M AUTOEXTEND OFF,
'/dev/rvd_txnrsp3' SIZE 9000M AUTOEXTEND OFF LOGGING ONLINE PERMANENT
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 200M BLOCKSIZE 2K;
2 3 4 5 6 7 8 CREATE TABLESPACE D_PATLOB DATAFILE
*
ERROR at line 1:
ORA-01144: File size (10245120 blocks) exceeds maximum of 4194303 blocks
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
