SQL & PL/SQL

Hi,

I have created the materialized view in oracle 9i as

Create materialized view Test_mv as select * from emp@db1;

Now In my database I am finding the materialized view object 'Test_mv' for which the local table (object) 'TEST_MV' is created.

Whenever materialized view is cretaed then correspondingly the table will be created with the same name.

My Question:
=========
1)I want to insert record into the table 'TEST_MV' but the materialized view will not allow to insert the record into the table 'TEST_MV'.

2) I want to drop this materialized view without droping its local table object 'TEST_MV'.

How could I preserve the local table when dropping the materialized view.

Please help me out by providing the suitable command.


Thanks in advance,

Captain S.P