|
-
Pando is right, the file is simply marked as offline in the controlfile. As the document say this allows you to open the database without the controlfile trying to checkpoint the file.
The original post however is possible if running under Unix as it is possible to physically remove the datafile while the database is running but the entry will still appear as valid until the data within that file is accessed or the database is bounced.
Regards
Jim
Oracle Certified Professional
"Build your reputation by helping other people build theirs."
"Sarcasm may be the lowest form of wit but its still funny"
Click HERE to vist my website!
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
|