Do NOT Confuse
If you have executed command "DROP TABLESPACE *** INCLUDING CONTENTS AND DATAFILES;" on oracle database it would be noticeable that table-space and data-files has been deleted from server metadata i.e. no entry can be seen in dba_tablespaces and dba_data_files object.
But if you move to data-file physical path on your machine (in which oracle is installed) you may able to see old data-files (do not worry)!!.
Now you are thinking that i have deleted table-space why these files are here or you would try to delete this manually.
Is it safe to do? , can you delete this manually?
Yes you can delete this manually
1. Stop the server
2. Restart the Server
3. Delete unwanted datafiles from physical location
If you have executed command "DROP TABLESPACE *** INCLUDING CONTENTS AND DATAFILES;" on oracle database it would be noticeable that table-space and data-files has been deleted from server metadata i.e. no entry can be seen in dba_tablespaces and dba_data_files object.
But if you move to data-file physical path on your machine (in which oracle is installed) you may able to see old data-files (do not worry)!!.
Now you are thinking that i have deleted table-space why these files are here or you would try to delete this manually.
Is it safe to do? , can you delete this manually?
Yes you can delete this manually
1. Stop the server
2. Restart the Server
3. Delete unwanted datafiles from physical location
No comments:
Post a Comment