Hello Guys, I am trying to duplicate a table from one schema to another.
when I do the import it fails with the following error.
ORA-31693: Table data object "SCOTT"."EMP" failed to load/unload and is being skipped due to error:
ORA-02354: error in exporting/importing data
ORA-39779: type "EMP"."SAL" not found or conversion to latest version is not possible
SCOTT.SAL is a user defined datatype. the schema from which the table is being duplicated has the datatype TEST.SAL.
I tried to using "create table scott.emp as select * from test.emp" bit it fails with ORA-00932
I tried to modify the scott.emp.sal coumn to use test.sal datatype, but it fails with ORA-22859: invalid modification of columns error
I tried to generate individual insert statements from toad, but my toad version is 9.0, so I couldnt do this.
Is there any option to disable the datatype while importing the data from one schema to another schema?
Thank You