Saturday, May 24, 2025

How to drop tablespace in oracle database ?

 



SQL> DROP TABLESPACE rcat INCLUDING CONTENTS AND DATAFILES;


Tablespace dropped.


SQL>

-

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

How to verify whether TIMED_STATISTICS changed between the oracle AWR database snapshots ?

To verify whether TIMED_STATISTICS changed between the snapshots used in your AWR Diff report, you can check the historical parameter value...