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