RE: problem with creating non default blocksize tablespace

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_at_freelists.org
To: fuadar_at_yahoo.com; oracle-l_at_freelists.org 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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]
On Behalf Of Fuad Arshad
Sent: Tuesday, September 14, 2004 11:34 AM To: oracle-l_at_freelists.org
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

--
http://www.freelists.org/webpage/oracle-l

--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l