GGSCI
(source.example.com as ggadmin@DB11G) 15> edit params extract1
-- Add parameters as per your requirement
-- Change Data Capture parameter file to extract
-- source table changes
--
EXTRACT extract1
USERIDALIAS srcdb DOMAIN admin
LOGALLSUPCOLS
UPDATERECORDFORMAT COMPACT
EXTTRAIL ./dirdat/aa
SOURCECATALOG pdb1
TABLE hr.EMPLOYEES;
TABLE hr.DEPARTMENTS;
GGSCI (source.example.com as ggadmin@DB11G) 16> add
extract extract1, integrated tranlog begin now
EXTRACT (Integrated) added.
GGSCI
(source.example.com as ggadmin@DB11G) 20> add exttrail ./dirdat/aa, extract
extract1, megabytes 100
EXTTRAIL added.
GGSCI
(source.example.com as ggadmin@DB11G) 21> info all
Program
Status Group Lag at Chkpt
Time Since Chkpt
MANAGER RUNNING
EXTRACT
STOPPED EXTRACT1 00:00:00 00:06:18
GGSCI
(source.example.com as ggadmin@DB11G) 22>
No comments:
Post a Comment