Skip to Main Content

Oracle Database Discussions

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!

expdp job names question

Harry MichealsOct 12 2017 — edited Oct 13 2017

We had an export datapump job abend last night due to temp space.  What I am curious about is the format of the job name that that was assigned.  I've seen job names assigned before, but I don't understand this one.  Here is a print out of the alert log that we get every morning.  What is the significance of the .1 and .2?

Scanned
[/ora01/app/oracle/diag/rdbms/XXXoctr/XXXOCTR/trace/alert_XXXOCTR.log]

found Oracle
Errors

Error found at 34 line in
[/XXX/admin/oracle/scripts/alertlog/logs/tmp_alertlog.txt] file

  Current log# 2
seq# 15074 mem# 0: /ora10/oradata/Q302OCTR/data/redo02.log

Thu Oct 12 02:40:23 2017

statement in resumable session
'OSA$ORACLE.SYS_EXPORT_FULL_01.1' was suspended due to

    ORA-01652:
unable to extend temp segment by 128 in tablespace TEMP Thu Oct 12 03:00:23
2017

ORA-1652: unable to extend temp segment by 128 in
tablespace                 TEMP

Thu Oct 12 03:23:00 2017

==============================================================

Error found at 36 line in
[/XXX/admin/oracle/scripts/alertlog/logs/tmp_alertlog.txt] file

statement in resumable session
'OSA$ORACLE.SYS_EXPORT_FULL_01.1' was suspended due to

    ORA-01652:
unable to extend temp segment by 128 in tablespace TEMP Thu Oct 12 03:00:23
2017

ORA-1652: unable to extend temp segment by 128 in
tablespace                 TEMP

Thu Oct 12 03:23:00 2017

statement in resumable session
'OSA$ORACLE.SYS_EXPORT_FULL_01.2' was suspended due to

    ORA-01652:
unable to extend temp segment by 128 in tablespace TEMP

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 10 2017
Added on Oct 12 2017
11 comments
492 views