miércoles, 13 de mayo de 2015

expdp error -3212 temporary segment cannot be creaetd in locally managed tablespace

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