Error: I got below error while import
Processing object type SCHEMA_EXPORT/USER
ORA-39083: Object type USER:"ABCD" failed to create with error:
ORA-02380: profile ABC_PROFILE does not exist
Failing sql is:
CREATE USER "ABCD" IDENTIFIED BY VALUES 'S:D6A96B73ECA93542E03C3479' DEFAULT TABLESPACE "DATA" TEMPORARY TABLESPACE "DATA" PROFILE "ABC_PROFILE"
Solution: Step-1 Create a profile before import.
CREATE PROFILE "ABC_PROFILE" LIMIT IDLE_TIME 15
Step-2 Remap table space name on imp job
remap_tablespace=XYZD_DATA:ABCD_DATA
remap_tablespace=XYZD_INDX:ABCD_INDX
Step-3 use below imp.par file vi imp.par
userid=system/password
dumpfile=ABCD%U.dmp
directory=dum_dir
logfile=ABCD_imp.log
parallel=8
cluster=N
transform=OID:n
job_name=abcdimp
remap_schema=XYZD:ABCD
remap_tablespace=XYZD_DATA:ABCD_DATA
remap_tablespace=XYZD_INDX:ABCD_INDX
Step-4 Then start import job again
nohup impdp parfile=imp.par &
No comments:
Post a Comment