Set up Extract (ext1) on DBMSCAP

To set up Extract (ext1) on DBMSCAP:

Register Extract with the downstream mining database. In the credential store, the alias name of ggadm1 is linked to a user connect string of ggadm1@dbms1. The alias name of ggadmcap is linked to a user connect string of ggadmcap@dbmscap.
```
DBLOGIN USERIDALIAS ggadm1
```
```
MININGDBLOGIN USERIDALIAS ggadmcap
```
```
REGISTER EXTRACT ext1 DATABASE
```
Create Extract at the downstream mining database:
```
ADD EXTRACT ext1 INTEGRATED TRANLOG BEGIN NOW
```
Edit Extract parameter file ext1.prm. The following lines must be present to take advantage of real-time capture. In the credential store, the alias name of ggadm1 is linked to a user connect string of ggadm1@dbms1. The alias name of ggadmcap is linked to a user connect string of ggadmcap@dbmscap.
```
USERIDALIAS ggadm1 TRANLOGOPTIONS MININGUSERALIAS ggadmcap TRANLOGOPTIONS 
INTEGRATEDPARAMS (downstream_real_time_mine Y)
```
Start Extract.
```
START EXTRACT ext1
```

Note:

You can create multiple Extracts running in real-time Extract mode in the downstream mining database, as long as they all are capturing data from the same source database, such as capturing changes for database DBMS1 in the preceding example.