Wednesday, September 28, 2011

STREAMS_CONFIGURATION parameter in Datapump.

It specifies whether or not to import any general Streams metadata that may be present in the export dump file.

Its default value is "y".


The following is an example of using the STREAMS_CONFIGURATION parameter. You can create the expfull.dmp dump file used in this example by running the example provided for the Export FULL parameter. See FULL.

C:\> impdp hr/hr DIRECTORY=dpump_dir1 DUMPFILE=expfull.dmp STREAMS_CONFIGURATION=n