-
I have dropped a datafile by,
-- deleting the file physically.
-- alter database datafile 'e:\...\...\x.prd' offline drop.
now the database is working fine but v$datafile still lists the datafile.
how can i get this cleared.
-
dropping data file
You need to drop the tablespace associated with the datafile and then physically remove the file.
-
on next shutdown & start your datafile will bee tracered as missing (you can not remove from there "dba_data_files" - until you don't make drop and create tablespace)
-
whoops
Yeah, the order is important.
What I do:
1. Drop TableSpace
2. Delete Datafile from Server
3. Remove the user associated with that tablespace (normally I have 1 user/connection per Schema/Tablespace, may not be best thing to do tho)
- Magnus
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
|