This problem happened in an enterprise test database , when exporting to standard edition.
Note www is a non oracle default user.
SET NLS_DATE_FORMAT=YYYY/MM/DD HH24:MI:SS
c:\app\11gent\product\11.2.0\dbhome_1\bin\expdp www/yyyy@xxx full=Y
directory=EXPDP dumpfile=EXPPERP_11G.dmp logfile=expdpPERP.log METRICS=Y
exclude=statistics
ORA-39006: internal error
ORA-39065: unexpected master process exception in DISPATCH
ORA-03212: Temporary Segment cannot be created in locally-managed tablespace
ORA-39097: Data Pump job encountered unexpected error -3212
SOLUTION: changed the user www to system and everything ok
c:\app\11gent\product\11.2.0\dbhome_1\bin\expdp SYSTEM/yyyy@xxx full=Y
directory=EXPDP dumpfile=EXPPERP_11G.dmp logfile=expdpPERP.log METRICS=Y
exclude=statistics
No hay comentarios.:
Publicar un comentario