extract to run the Extract program from the command line of the Linux, UNIX, Windows, or IBM i operating system. The
extract command is installed in the Oracle GoldenGate installation directory or library.
extract paramfile parameter_file [atcsn CSN | aftercsn CSN] [initialdataload] [pauseatend | nopauseatend] [processid PID] [reportfile report_file] [usesubdirs | nousesubdirs]
Used without options, the command runs the program interactively.
Required. Specifies the relative or absolute path name of the parameter file for the Extract program that is being run. The default location is the
dirprm subdirectory of the Oracle GoldenGate installation directory.
Starts the process at or after the specified commit sequence number (CSN). For more information, see "START EXTRACT".
Runs Extract to extract all of the data records directly from the source database to support an initial load to the target.
pauseatend | nopauseatend
(Windows only) When the process stops, requires an Oracle GoldenGate user to look at the console output and then strike any key to clear it. Also indicates whether the process ended normally or abnormally.
A name for the process. This name must match the name that is specified for the
EXTRACT parameter in the parameter file. Use one alphanumeric word. When used on IBM i, this name (up to the first 10 characters) will be used as the job name in the IBM i job list.
Sends command output to the specified report file. Without the
reportfile option, the command output is printed to the screen. The default is the
dirrpt subdirectory of the Oracle GoldenGate installation directory.
usesubdirs | nousesubdirs
Includes the Oracle GoldenGate subdirectories when the process searches for a file to open.
usesubdirs is the default.
EXTRACT PARAMFILE(input_file) [OTHERS(other_options)]
The input text file, known as an
OBEY file, containing the commands that you want to issue, in the order they are to be issued, one command per line. The name can be anything supported by the operating system.
Any options that are supported in the UNIX version of the command provided as a space separated list.