Droping Materialized View but preserve its local table - Oracle 9i

Exor

Hello gurus,

How would one drop a materialized view in 9i but preserve the table?

Thank you,

Unknown

How would one drop a materialized view in 9i but preserve the table?

Dropping the MV will drop the table unless the MV was created on a prebuilt table.

If you have licensed the PARALLEL option you can use EXCHANGE PARTITION to swap the MV segment to a work table with ONE empty partition.

Then you can drop the MV and the (now empty) table.

Then create a standard table and use EXCHANGE PARTITION again to swap in the data segment from the work table.

Unknown

How would one drop a materialized view in 9i but preserve the table?

Dropping the MV will drop the table unless the MV was created on a prebuilt table.

If you have licensed the PARALLEL option you can use EXCHANGE PARTITION to swap the MV segment to a work table with ONE empty partition.

Then you can drop the MV and the (now empty) table.

Then create a standard table and use EXCHANGE PARTITION again to swap in the data segment from the work table.

Exor

Thank you very much,