For dropping the TABLESPACE and USER
1. DROP TABLESPACE <TABLESPACE_NAME> INCLUDING CONTENTS AND DATAFILES;
2. DROP USER <USER_NAME> CASCADE;
Always we need to drop the Tablespace FIRST and then associated user. with this sequence only we can make sure that we erase the data perfectively.
or we would face some issue like the .DBF would not get removed then we need to stop the ORACLE service and then delete the .DBF file manually which is not good way.
1. DROP TABLESPACE <TABLESPACE_NAME> INCLUDING CONTENTS AND DATAFILES;
2. DROP USER <USER_NAME> CASCADE;
Always we need to drop the Tablespace FIRST and then associated user. with this sequence only we can make sure that we erase the data perfectively.
or we would face some issue like the .DBF would not get removed then we need to stop the ORACLE service and then delete the .DBF file manually which is not good way.
No comments:
Post a Comment