Oracle Database Discussions

Hi All

i have a task to export a schema to different database.

when i did that it copied all objects except a materialized view. when i tried to cerate it manually it says already exist because of same tablename.

source schema: where we have table and materialzed view with same name
OWNER OBJECT_TYPE OBJECT_NAME STATUS
------------------------------ ------------------- -------------------- -------
XYZ TABLE ABC_DATA VALID
XYZ MATERIALIZED VIEW ABC_DATA VALID
XYG INDEX PK_T_SSL_TEL VALID
XYZ DATABASE LINK SSSBDC.RAACPC VALID

How do i create this in new schema?

how to solve this ?

thanks in advance

ryan