-
Hi,
I am running oracle 8.1.6 instance having more than 2TB size in DEC station. One of the datafile of one of the tablespace got accidentely deleted. What I thought is to drop this datafile and recreate another one with same name and size.
To remove the things back what I did..
svrmgrl>startup mount
>alter database datafile '...' offline drop;
> statement processed.
>alter database open
Interesting thing is that though alter database datafile '...' offline drop shows statement processed but when I see dba_data_files data dictionary tables this data file is still there and that is the reason I am not able to recreate the same with the same name and size.
Any help will greatly appreciated.
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
|