Please send your Questions & Answers or Feedback to "dvmadhavreddy@javabook.org"

Please send your Questions & Answers or Feedback to "mohan@javabook.org"

Undo Retention

SQL> alter tablespace undotbs2 retention guarantee;

SQL> alter tablespace undotbs2 retention noguarantee;

SQL> alter tablespace undotbs2 offline;

                ORA-30042 : cannot offline undo tablespace

SQL> alter tablespace undotbs1 offline;

SQL> alter tablespace undotbs1 online;

SQL> alter system set undo_tablespace=undotbs1;

No comments:

Post a Comment

Related Posts Plugin for WordPress, Blogger...

Flag Counter