NOUSERID
Valid For
Extract, Replicat, DEFGEN, and Admin Client.
Supported for
Oracle AI Database.
Description
Use NOUSERID to allow integrated Extract to run without
a connection for fetching or metadata lookups, or any data dictionary calls.
Essentially eliminating the need to connect to the source database at all. The
NOUSERID option requires an integrated dictionary.
If you have an Active Data Guard Standby server when
NOUSERID is used, then you can set up fetching from that
Standby database using the FETCHUSERID parameter. The two can be
used in conjunction with NOUSERID.
If you are using downstream integrated Extract, you can use
FETCHUSERID to fetch from the ADG Standby database and
NOUSERID to prevent the Extract from making a connection to the
source database. This way, if Extract does need to fetch the
USERID, it can do so. For more details, see Downstream Database Configuration for Active Data Guard and
GoldenGate.
The NOUSERID option does
not allow the use of SQLEXEC in the Extract parameter file.
Default
None