Oracle asking for the dropped datafile....

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