Skip to Main Content
Forums

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Scheduler$_event_queue - Job Events of other Schemas

JogiFeb 17 2011 — edited Apr 1 2011
Hi all,

in a PL/SQL Procedure we dequeue the Scheduler$_event_queue. it works fine.

but, how can i receive/dequeue event queue messages from jobs which are created in other schemas?

thx in advance

joerg

Edited by: Joerg Baltrusch on 17.02.2011 13:30

Comments

MateuszH

hi,

Traditional Import (IMP) Raises Error IMP-51 Direct Path Exported Dump File Contains Illegal Column Length (Doc ID 1403865.1)

Instead of using the traditional export/import, use the DataPump export/import as a workaround.

So just use impdp/expdp instead of imp/exp

m.

Dean Gagne-Oracle

There is a little more than just using 'expdp/impdp', but I agree, you should be using Data Pump instead of the original exp/imp tools.  Data Pump has been around since 10.1 and has a lot more features and potentially bug fixes than exp/imp may have.  Since your source and target are both later than 10.1, Data Pump is the way to go.  You should be able to use most of your parameters, Data Pump will convert them for you.  What you will need to do is create a directory and directory object for Data Pump to use.

Dean

1 person found this helpful
1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Apr 29 2011
Added on Feb 17 2011
#database-key-features, #scheduler
3 comments
320 views