create tablespace uniform size problem

From: <mail2atulmehta_at_yahoo.com>
Date: 31 Oct 2005 08:45:17 -0800
Message-ID: <1130777117.889514.246380_at_g49g2000cwa.googlegroups.com>



Hi,

I am using the following query to create a tablespace, but it is giving

me an error, I thik it is becaue of the uniform size. Any help? The error says "atleast 5 blocks ". So how do i increase the blocks? CREATE TABLESPACE INDEX02
      DATAFILE 'c:\oracle\product\10.2.0\oradata\INST1\INDEX02.dbf' SIZE 2M
REUSE

        AUTOEXTEND ON NEXT 500K MAXSIZE 5M
        EXTENT MANAGEMENT LOCAL UNIFORM SIZE 4K
        PERMANENT 
        ONLINE; 


thanks. Received on Mon Oct 31 2005 - 17:45:17 CET

Original text of this message