Re: Help!! data file was deleted
From: B C Zygmunt <bzy_at_ornl.gov>
Date: 1995/10/07
Message-ID: <455tss$rur_at_stc06.ctd.ornl.gov>#1/1
Date: 1995/10/07
Message-ID: <455tss$rur_at_stc06.ctd.ornl.gov>#1/1
This is pretty simple to fix:
- Start sqldba
- connect internal [if version 7]
- startup mount
- alter database datafile 'the_name_of_the_dropped file' offline;
- alter database open;
- drop tablespace the_one_you_need_to_drop;
- shutdown
- startup
Hope this helps.
/beverly
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++Received on Sat Oct 07 1995 - 00:00:00 CET
+ + +
+ Beverly Cather Zygmunt + Phone: (615) 574-1007 +
+ Oak Ridge National Laboratory + email: zygmuntbc_at_ornl.gov +
+ Building 4500N, MS 6274 + bzy_at_ornl.gov +
+ Oak Ridge, TN 37831-6274 + +
+ + +
+ + +
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
+ +
+ "If you torture your data long enough, they will tell you what +
+ you want to hear." -- James L. Mills +
+ +
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++