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

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

RE: problem with creating non default blocksize tablespace

From: Darrell Landrum <darrell_at_landrum.com>
Date: Tue, 14 Sep 2004 12:08:32 -0500
Message-Id: <20040914170836.5AB6C72C09B@turing.freelists.org>


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
Received on Tue Sep 14 2004 - 12:04:06 CDT

Original text of this message

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