1) Add a data file
ALTER TABLESPACE ts03
ADD DATAFILE
'/data1/oradata/ts03-b.dbf'
SIZE 200M ;
ALTER TABLESPACE ts01
ADD DATAFILE
'/data/disk12/dataxx44.dbf' SIZE 200M
AUTOEXTEND ON NEXT 10M
MAXSIZE 500M;
2) or, resize current data file
alter database datafile '/u01/oradata/orcl/users01.dbf' resize 50M;
3) or, change the storage / extent configuration
ALTER TABLESPACE ts01
DEFAULT STORAGE (
INITIAL 200M NEXT 200M MAXEXTENTS 10 ) ;
/* Altering the default storage for a tablespace */
ALTER TABLESPACE TEMP01 DEFAULT STORAGE (PCTINCREASE 0)
ALTER TABLESPACE TEMP01 DEFAULT STORAGE ( initial 1M next 1M )
|
|
