Drop the TableSpace , User ORACLE

                                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.

Database Export and Import in Oracle of .DMP (Dump File)

ORACLE

For exporting the Database :

expdp system/Password@SID full=Y dumpfile=CMDB.dmp logfile=CMDB10G.log

For importing the Database :


impdp system/Password@SID full=Y dumpfile=CMDB.dmp logfile=CMDBIMPORT10G.log