I have a db with 6 newly added tablespaces with a dbf file associated with each. 3 suffixed with A and the other 3 with B,
The application created these tablespaces through a script I have been assured by the developer. That I can drop the ones suffixed with a B as they are no longer reqd. However when I put a trace on I see that nothing is referencing the B's so they seem safe to drop, although when I do an ls from the command line all the dbf files are modified with the current time
Am I missing something here?
Thanks in advance!
I suppose that the attribute of the datafile is to depend on the OS.
Just take the tablespace offline before droping it.
Oracle Certified Master - September, 2003, the Second OCM in China
*** LOOKING for PART TIME JOB***
Data Warehouse & Business Intelligence Expert
MCSE, CCNA, SCJP, SCSA from 1998
the timestamp changes because Oracle writes to the headers of these files and certain point, e.g log switches
Check to make sure no segments are in those tablespaces (select * from dba_Segments where tablespace = 'foo'), take them offline, drop the tablespace, and then remove the files using an OS command such as rm or del.
Click Here to Expand Forum to Full Width