database version: 11.2.0.4.0
compatible parameter: 11.2.0.0.0
OS version Sparc 64 bit
Hello guys I am facing the error "ORA-39779: type "<schema2>"."<type_name>" not found or conversion to latest version is not possible while import" while trying to import into a target database.
Where ever I checked all of them told to use the parameter transform=oid:n, I already used that parameter and i am still getting the error.
in one thread one person said, it might be because the users are already created in the database before the import started.
Did some one face this problem in the past, please help me.
Thank You
expdp parameter file
directory=<directory_name>
dumpfile=<dumpfile_name>_%U.dmp
logfile=<logfile_name>.log
parallel=8
compression=all
schemas=schema1, schema2, schema3
exclude=grant
impdp parameter file
directory=<directory_name>
dumpfile=<dumpfile_name>_%U.dmp
logfile=<logfile_name>.log
parallel=8
schemas=schema1, schema2, schema3
remap_schema=schema1:schema1, schema2:schema2, schema3:schema3
transform=oid:n
remap_tablespace=<tablespace_1>:<tablespace_2>