Re: understanding syntax CREATE TABLESPACE problem

Atali Daoud wrote:

> Hi,
>
> I have the following statement but I don't understand something.
>
> what the option "USER" before DEFAULT STORAGE meaning in that statement?
>
> CREATE TABLESPACE "CV_ROLLBACK" DATAFILE
> '/u3/oracle/oradata/cvision/cv_rbs.dbf' SIZE 3820M REUSE AUTOEXTEND ON
> NEXT 8192 MAXSIZE 32767M, '/u3/oracle/oradata/cvision/cv_rbs_1.dbf'
> SIZE 209715200 REUSE AUTOEXTEND ON NEXT 10485760 MAXSIZE 32767M,
> '/u3/oracle/oradata/cvision/cv_rbs_2.dbf' SIZE 209715200 REUSE
> AUTOEXTEND ON NEXT 10485760 MAXSIZE 32767M EXTENT MANAGEMENT LOCAL
> USER DEFAULT STORAGE(INITIAL 20971520 NEXT 20971520 MINEXTENTS 20
> MAXEXTENTS 4096 PCTINCREASE 50) ONLINE PERMANENT
>
>
> Thanks.
> Atali

As far as I can tell (from the Oracle9i R2 SQL Reference manual, CREATE TABLESPACE section) the 'USER' clause is not legit.

I don't think that's the only problem, though. From the same document (available at http://docs.oracle.com) we have the following quote:

"If you specify LOCAL, then you cannot specify DEFAULT storage_clause, MINIMUM EXTENT, or TEMPORARY."

And then there's the question of why you are using rollback segments instead of undo segments ... perhaps an old version of the software?

DB version and operating system would be nice! /Hans Received on Mon Aug 30 2004 - 10:32:39 CDT