Skip to Main Content

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!

Exporting and Importing the schema with AQ capability

HesipesiMar 5 2013
Hi,

We have a production DB which is using Advance queuing and this whole queuing is working fine in Prod but now we have a problem in test Env and it seems that somebody has already tampered the test DB. (the queue reads and sends the messages to DB2)

So i wanted to export the prod schema and import it to the test schema that we have.
i wanted to make sure that if i import it to test db , it doesn't send the messages to the prod DB2 database!!

now it should send the messages to the test DB2 database.

How can i see where it sends the messages after i imported it ? how can i change it?
i'm not sure if i have explained my problem in a correct way and if you have understood my question. Please send me messages and i can explain more about it.

Comments

Your post doesn't have enough detail to identify a cause.

How did you install Instant Client? Did you set PATH?

Don't copy oci8.dll. It is too easy to get a conflicted set up.
1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Apr 2 2013
Added on Mar 5 2013
0 comments
531 views