CREATE TABLESPACE "PS_DEFAULT"
LOGGING DATAFILE '/oradata/psprod/data/ps_default.dbf' SIZE 50M REUSE
AUTOEXTEND ON NEXT 1024K MAXSIZE 200M
DEFAULT STORAGE ( INITIAL 1024K
NEXT 1024K
MINEXTENTS 1
MAXEXTENTS 200
PCTINCREASE 0 )
/
CREATE TABLESPACE "BNAPP"
LOGGING DATAFILE '/oradata/psprod/data/bnapp.dbf' SIZE 10M REUSE
AUTOEXTEND ON
NEXT 5120K
MAXSIZE 100M
DEFAULT STORAGE ( INITIAL 64K
NEXT 128K
MINEXTENTS 1
maxextents 200
pct increase 0 )
/
CREATE TABLESPACE "HRAPP"
LOGGING DATAFILE '/oradata/psprod/data/hrapp.dbf' SIZE 120M REUSE
AUTOEXTEND ON NEXT 5120K
MAXSIZE 240M
DEFAULT STORAGE ( INITIAL 64K
NEXT 128K
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0 )
/
++++++++++++++++++++++++++++++++++++++++
THE LIST GOES ON FOR APPROX 40 MORE TABLES!!!!
I need to cut the storage clause out form all these tables, if I do this manually it will take hours!!
The brain is a wonderful organ; it starts working the moment you get up in the morning and does not stop until you get into the office.