yes it prevents users writing to the datafile... but it leaves your
database in a precarious state if you have to do recovery.. or if you
do a shutdown and try to open the database normal.
--- Sherman, Paul R. [EMAIL PROTECTED] wrote:
Hello Jared et al,
The Oracle Reference Manual for 8i,
Hello list,
Oracle 8.1.6.3.0, on HP-UX 11.0, using Oracle Parallel Server (OPS)
According to Oracle, I should be able to drop a datafile that has no data
written to it, but I can not. Neither DBA studio (the garbage can stays
'grayed'), nor the command line (alter tablespace, with the DROP
You can't safely drop a datafile from the database.
When you say 'According to Oracle, I should be able to drop a datafile
at has no data written to it', do you have a reference where we can
see that. It does not sound familiar to me.
Per your situation, since you have the datafile offline,
Hello Jared et al,
The Oracle Reference Manual for 8i, schematic diagram has alter database
database 'datafile' offline drop, so that's what I tried (as system).
The system came back, 'database altered', but a check of dba_data_files
shows that the datafile (#115) is still there. The dba_extents
But, offline and removed from the system are two different things...
You are correct that your datafile is offline... That just means that it is
unavailable for use... But, it is still part of your database... The DROP
keyword does not mean that the datafile is removed from the system... It
