Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> problem with creating non default blocksize tablespace

problem with creating non default blocksize tablespace

From: Fuad Arshad <fuadar_at_yahoo.com>
Date: Tue, 14 Sep 2004 09:34:12 -0700 (PDT)
Message-ID: <20040914163412.33448.qmail@web80512.mail.yahoo.com>


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
Received on Tue Sep 14 2004 - 11:29:43 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US