materialized views in export

[naushi]

I am exporting a table from database A and importing into database B. The table has materialized view attached to it which I dont want to export. When I import the table into database B it gives me an error that the table has attached Mview. How can I export the table so it would not carry the attachment with it or do I need to import using a certain parameter that would not cause the error.

I treid constraints=n but it still errors out.

Will appreciate some clue. Regards,
Naushi Hussain
Naushi.hussain@honeywell.com

 

[steenb]

just a thought :
is sql*loader better at this ?
regards
Steenb

 

[naushi]

well I found out from the knowledge base that there is a bug in 8i. Now I ignore the error since the table imports fine and I dont care about the view. Regards,
Naushi Hussain
Naushi.hussain@honeywell.com