Sunday, July 19, 2020

Rename or Move the datafile

1)Make the tablespace offline 

 alter tablespace  offline;


2)MV the all the datafile to new location or rename them 

3)Run the command 

alter database rename file 'C:\ORACLE\DBI\ORADATA\SIT01\test01.dbf' to 'C:\ORACLE\DBI\ORADATA\SIT01\redo\test01.dbf' 
at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Plan SQL's

SELECT sql_id, plan_hash_value, executions, inst_id FROM gv$sql WHERE sql_id='bhwamkg4y2pxb'; SELECT ...