Re: create tablespace creating a problem

From: Eric de Redelijkheid <ericdere_at_xs4all.nl>
Date: Mon, 31 Oct 2005 20:31:51 +0100
Message-ID: <43667126$0$11073$e4fe514c@news.xs4all.nl>

Anno Domini 31-10-2005 16:54, mail2atulmehta_at_yahoo.com sprak aldus:

>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. Any6 help?
>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.
>
>
>

What is your blocksize? 4k seems smallish. Received on Mon Oct 31 2005 - 13:31:51 CST