1. Microservices Architecture Documentation
  2. Extract
  3. Register an Extract
  4. Registering Extract for Oracle

Registering Extract for Oracle

Follow these instructions to register an Extract. Extract registration must be done prior to creating an Extract.

Ensure that you are connected with the database using the DBLOGIN command.

See REGISTER EXTRACT in the Command Line Interface Reference for Oracle GoldenGate for more information.

  1. Using the Admin Client, connect to the deployment, then connect to the credential alias for the source database.
    OGG> CONNECT https://remotehost:srvmgrport DEPLOYMENT deployment_name AS deployment_user PASSWORD deployment_password
    When running the CONNECT command, the command prompt changes from "not connected" to "https://servername:port deployment_name", as shown in the following code snippet.
    OGG (https://remotehost:16000oracle_source)> DBLOGIN USERIDALIAS alias
  2. Register the Extract, which internally creates a replication slot for the Extract. Extract names cannot be more than 8 alpha-numeric characters.
    OGG (https://remotehost:16000oracle_source)> REGISTER EXTRACT extname

You can also register an Extract in the background while creating an Extract from the Oracle GoldenGate MA web interface. See Add an Online Extract for details.