Datafile has been removed already , But I still can find its information in V$datafile
why?
Printable View
Datafile has been removed already , But I still can find its information in V$datafile
why?
Unless you offline and remove the datafile with a drop command the entry will remain in the data dictionary. Simply removing the datafile will not remove it association with the Oracle database.
Regards
would you please tell us how did you remove the datafile...means using what command??
as per my knowledge .
once created datafile cannot be dropped through normal sql syntax . tablespace associated with the datafile can be dropped, which removes the datafile from v$datafile.
alter database datafile 'xxx' offline drop;
Or if it is the only datafile in the tablespace,
Drop tablespace name including contents;
offlince drop a datafile will force you to drop entire tablespace
Pando, what do u mean by 'force to drop entire tablespace'? I agree that offline a datafile means that u may drop the tablespace at a later time and not that U will be forced to drop it.
after droping the datafile . i believe we cannot make it online
with a similar syntax . only option it leaves is to recover the database if it is in archivelog mode .
is this syntax valid prior to version 8 .
I think we moved from the actual question posed. The one line reply is:
"References to the dropped datafiles are not eliminated from views unless the tablespace in which they exist is recreated or dropped. "
Quote:
Originally posted by soniaarora
Pando, what do u mean by 'force to drop entire tablespace'? I agree that offline a datafile means that u may drop the tablespace at a later time and not that U will be forced to drop it.
may?
no, you are forced to, you cant never ever remove a datafile from a tablespace