Re: understanding syntax CREATE TABLESPACE problem

From: Atali Daoud <adaoud_at_refco.fr>
Date: Mon, 30 Aug 2004 17:37:39 +0200
Message-ID: <41334aae$0$29678$636a15ce@news.free.fr>

In fact, I did an export from 8i (Sun Solaris) and I would like to import it in a new database 9i (Sun Solaris too).

Thanks you to answer so quickly ;)

Hans Forbrich wrote:

> 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:37:39 CDT