Re: Oracle asking for the dropped datafile....

The reason the file shows as recover is because you can not drop a file from a tablespace, you now have to recreate the tablespace.

Regards
David Russell

Tansel Ozkan wrote in message <352FBD8E.4BFA_at_openix.com>...
>Hello all,
>
>Somebody in our group first added a new datafile to a tablespace
>thinking that there was more space needed to load new data. However,
>after realizing that that was not the case, he dropped the datafile
>using 'Alter database datafile 'filename' offline drop;'. However,
>before dropping this datafile, he attempted to load some data, and
>according to his account, he only loaded 26 records. Even after dropping
>the datafile, the v$datafile dictionary table shows the file in
>'recover' status, and when we try to load new data to the new tablespace
>after a certain point, probably when the first datafile is full, it is
>giving an error message asking for the dropped datafile. We tried
>truncating the table and dropping the table to be loaded so that all its
>storage parameters not used.
>Does oracle keep all the datafile names even after they are dropped?
>
>Any suggestions..
>
>Thanks..
>
>Tansel
Received on Sat Apr 11 1998 - 00:00:00 CDT