AQ Propergation fails after import

[jovery]

To all you AQ experts, this is driving me nuts.......

...The setup...

We have three databases DB1 (8.1.7 solaris), DB2 (8.1.7 solaris) and DB3 (9.2.03 solaris).

We have a user ENT on all databases.

We have AQ setup DB2 --> DB3 across a link ENTMIS going from queue ENT.ENT_LOAD_QUEUE --> ENT.MIS_LOAD_QUEUE.

...What happened...

I took an export of the ENT user from DB1, dropped the ENT user on DB3, recreate the user with the same privileges as before and imported the data from DB1.

Now the queue propegation from DB2 --> DB3 fails with the following error (reported by DB2):

"ORA-21700: object does not exist or is marked for delete
ORA-02063: Message 2063 not found; No message file for product=RDBMS, facility=ORA; arguments: [] [line] [ENTMIS] []"

All the queues exist as before and all the privileges are the same, Oracle are as useful as ever and it's driving me insane.

Thanks in advance

[rotem_fo]

Check if after import the queue is enabled:
---- code starts here ----

SELECT NAME, ENQUEUE_ENABLED, DEQUEUE_ENABLED
FROM USER_QUEUES;

---- code ends here ----

[jovery]

Yes, the queues are enabled.