Oracle bi-directionals streams propagates source to target but not target to source
Creating Oracle bi-directional streams.  The data will propagate from source to target.  The instatiation was created on the target using datapump.  The target to source does not propagate.  See a trace file that contains the error: instantiate scn is invalid commit scn is valid. Instantiate the source as follows: DECLARE[/pre]   iscn  NUMBER;         BEGIN[/pre]   [...]

Answer Question   |  December 3, 2009  5:55 PM
Data Pump, Oracle Streams, Solaris

Data Pump REMAP_TABLE parm
I’m trying to use the remap_table parm in the impdb phase of data pump. I’ve done an expdb from a production database and I’m trying to copy it into a different schema, tablespace and table. The table on the receiving database is set up the same as the table in production. When I try to [...]

Answer Question   |  July 31, 2008  6:05 PM
Data Pump