Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> understanding syntax CREATE TABLESPACE problem

understanding syntax CREATE TABLESPACE problem

From: Atali Daoud <adaoud_at_refco.fr>
Date: Mon, 30 Aug 2004 17:14:01 +0200
Message-ID: <41334524$0$29679$636a15ce@news.free.fr>


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 Received on Mon Aug 30 2004 - 10:14:01 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US