Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

data pump error

User_U9EN2Jan 18 2020 — edited Jan 21 2020

Hi All,

I got an error in my alert log while exporting;

ORA-1688: unable to extend table SYS.WRH$_ACTIVE_SESSION_HISTORY partition WRH$_ACTIVE_756806621_0 by 8192 in tablespace SYSAUX

Suspending MMON slave action kewrmafsa_ for 82800 seconds...

Added a datafile to SYSAUX tablespace. The exp log shows hung at the table where job was suspended

ps -ef | egrep 'ora_dm|ora_dw' | grep -v egrep ;

oracle 20864 1 0 11:30 ? 00:00:28 ora_dm00_PP

oracle 20893 1 11 11:30 ? 01:19:26 ora_dw00_PP

oracle 24444 1 12 11:57 ? 01:27:04 ora_dw01_PP

oracle 24446 1 1 11:57 ? 00:08:41 ora_dw02_PP

oracle 24448 1 8 11:57 ? 01:01:57 ora_dw03_PP

oracle 24450 1 13 11:57 ? 01:34:37 ora_dw04_PP

oracle 24452 1 13 11:57 ? 01:33:35 ora_dw05_PP

Will the data pump job resume automatically OR need to attach and resume?

Added on Jan 18 2020

#database-key-features, #export-import-sql-loader-external-tables

1 comment

187 views