Re: Newbie question about Tablespaces (and database creation).

Thanks, just for clarity

Should it be:

CREATE TABLESPACE APPL_DATA DATAFILE 'APPL_DATA' SIZE 100M AUTOEXTEND ON NEXT 10M MAXSIZE 1000M DEFAULT STORAGE
( INITIAL 100M NEXT 10M
MINEXTENTS 1
MAXEXTENTS 10 PCTINCREASE 1 )
MINIMUM EXTENT 10M; or just

CREATE TABLESPACE APPL_DATA DATAFILE 'APPL_DATA' SIZE 100M AUTOEXTEND ON NEXT 10M MAXSIZE 1000M ; Then when I create the table do I specify a real size for initial (how should I determine extent size for the table)?

-greg

• Posted from RemarQ - http://www.remarq.com - Discussions Start Here (tm) ****