EXPORT/IMPORT AQ with many subscribers
Hi,
My envirnoment is MS Server 2003 and 10.1.0.4 DB
I have the following requirement:
1. Two way replication type hub - one central DB and many local, each local contains info only for itself.
2. If for any reason connection between any of the local and the central DB is not working I must make an "offline" replication through files.
Has anyone done this with Data pump export/import?
Quote(Oracle® Streams Advanced Queuing User's Guide and Reference):
"The truncate and append modes are not supported for queue tables. The behavior in this case is the same as the replace mode."
Because of this I can't export/import utility I think...
My other idea is to select into external table all data from AQ$_queue_table_P dictionary table and then to delete the selected rows and to insert them to the appropriate location. This works somehow but I can't be sure because I didn't found no explanation of this way...
Any other ideas or suggestions?
Had anyone did this before?
Thank you
Svetoslav