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".

Example:

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

Enjoy:-)