Hi,
I'm doing a schema export with these command:
expdp user/pass schemas=ctm920 directory=BACKUP_DIRDC logfile=backup.log filesize=1G
Then I need to recover the schema. To do that I do:
impdp user/pass dumpfile=expdat.dmp logfile=log.log directory=BACKUP_DIRDC schemas=ctm920 TABLE_EXISTS_ACTION=REPLACE
But when I do the import shows me a lot of ora message like these:
ORA-31684: El tipo de objeto FUNCTION:"ctm920 "."CURRTIME" ya existe
ORA-39346: perdida de datos en la conversion del juego de caracteres del objeto PROCEDURE:"ctm920 "."CLEAN_AJF_V9"
ORA-31684: El tipo de objeto PROCEDURE:"ctm920 "."PURGE_CMR_RUNINF_1" ya existe
ORA-39111: Se ha saltado el tipo de objeto dependiente ALTER_FUNCTION:"ctm920 "."DDIFF", ya existe el tipo de objeto base FUNCTION:"ctm920 "."DDIFF"
How could I can avoid that? I need to restore de schema that I've exported. Thanks!