Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> understanding syntax CREATE TABLESPACE problem
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