Re: Lost datafile for dataless partition

The solution to the problem given by the ORA-14404 is to convert the affected partition into a table.

Create a temporary table with the exact same properties as the original

    CREATE TABLE <temp table> AS SELECT * FROM <orig table> where 1=2;

Use 'exchange partitions' on the affected partition to convert it into a table ALTER TABLE <table name> EXCHANGE PARTITION <part name> WITH TABLE <temp table> WITHOUT VALIDATION;

The tablespace should now be droppable. (assuming no other partitoins exist within it)

.....if you really want it back as empty, recreate and re-exchange...

Cheers
CT Received on Wed Jan 08 2003 - 14:44:59 CST