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'
SQL exection per day SELECT TO_CHAR(s.BEGIN_INTERVAL_TIME, 'YYYY-MM-DD') AS execution_date, ss.SQL_ID, SUM(ss.EXECUT...
No comments:
Post a Comment