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' 

No comments:

SQL executions based on AWR

SQL exection per day SELECT TO_CHAR(s.BEGIN_INTERVAL_TIME, 'YYYY-MM-DD') AS execution_date, ss.SQL_ID, SUM(ss.EXECUT...