For making Table space offlie:
ALTER TABLESPACE data1 OFFLINE NORMAL;
For Renaming data file
ALTER TABLESPACE data1
RENAME DATAFILE 'data1.dbf'
TO 'data1_new.dbf';
For making Table space online:
ALTER TABLESPACE data1 ONLINE;
ALTER TABLESPACE data1 OFFLINE NORMAL;
For Renaming data file
ALTER TABLESPACE data1
RENAME DATAFILE 'data1.dbf'
TO 'data1_new.dbf';
For making Table space online:
ALTER TABLESPACE data1 ONLINE;
No comments:
Post a Comment