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.

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 example:
```
OGG (https://pdbeast.vcn.oracle.com:16000depl_east)>
```

Connect to the database using the DBLOGIN command:

OGG (https://remotehost:portoracle_source)> DBLOGIN USERIDALIAS alias

Register the Extract. The Extract names cannot be more than 8 alpha-numeric characters.
```
OGG (https://remotehost:portoracle_source)> REGISTER EXTRACT extname DATABASE
```

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.