-
Hi,
How do I drop the datafiles?
Please let me know.
-
You should not be dropping the datafile. The correct way is to drop the tablespace and then remove the datafiles from the OS.
Check this thread --
http://dbasupport.com/forums/showthr...?threadid=6697
- Rajeev
Rajeev Suri
-
droping the datafile
First...bring the tablespace offline...
Alter tablespace tablespace_name offline;
check the status of the tablespace....
drop tablespace tablespace_name...
and at os level...
rm datafile name.
it will work.
good luck.
Thanigaivasan
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|