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,
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