And ... what is the error number that you get ?
Note : If you are creating a tablespace with the non-standard blocksize, you must have db_cache_Xk_size configured and running for your instance before you create the tablespace.
Hemant At 08:29 AM 23-01-04 -0800, you wrote:
I tried to create tablespace with 16K (default on my init.ora blocksize =8k). I have error happen. The database version is 9.2.0.4.
SQL> create tablespace "index1" logging datafile '/u0/oradata/leg92/index1.dbf' size 20m 2 blocksize 16384 3 autoextend on 4 next 1280k 5 maxsize unlimited 6 extent management local 7 segment space management auto 8 uniform size 128k; autoextend on * ERROR at line 3:
if I take out "blocksize 16384", then it work fine.
SQL> create tablespace "index1" logging datafile '/u0/oradata/leg92/index1.dbf' size 20m 2 reuse autoextend on 3 next 1280k 4 maxsize unlimited 5 extent management local 6 segment space management auto 7 uniform size 128k;
Tablespace created.
Does anyone know why??
__________________________________ Do you Yahoo!? Yahoo! SiteBuilder - Free web site building tool. Try it! http://webhosting.yahoo.com/ps/sb/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: dba1 mcc INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Hemant K Chitale Oracle 9i Database Administrator Certified Professional http://hkchital.tripod.com {last updated 22-Jan-04}
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).