ORA-01690: sort area size too small
In fase di export con Oracle Data Pump su un database Oracle 11gR2, versione 11.2.04, è comparso il seguente messaggio di errore.
expdp '"/ as sysdba"' dumpfile=pap.ump logfile=pap-log schemas=PAP;
Termina in errore con il messaggio
ORA-01690: sort area size too small
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPW$WORKER", line 8164
Come Workaround usare le utiliti "exp" e "imp"
exp '"/ as sysdba"' file=pap.dump log=pap-log owner=PAP;
imp '"/ as sysdba"' file=pap.dump log=pap_imp.log fromuser=PAP touser=PAP;
expdp '"/ as sysdba"' dumpfile=pap.ump logfile=pap-log schemas=PAP;
Termina in errore con il messaggio
ORA-01690: sort area size too small
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPW$WORKER", line 8164
Come Workaround usare le utiliti "exp" e "imp"
exp '"/ as sysdba"' file=pap.dump log=pap-log owner=PAP;
imp '"/ as sysdba"' file=pap.dump log=pap_imp.log fromuser=PAP touser=PAP;