Skip to Main Content

GoldenGate

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

No active extraction maps. reported from stats on datapump

User_2M72IJan 6 2012 — edited Jan 6 2012
Hello All

I have a datapump that I am getting the following on after running a stats on the datapump process.

GGSCI (jims.env) 153> stats epmpdp

Sending STATS request to EXTRACT EPMPDP ...

No active extraction maps.

This was working but I reloaded one of the tables that the pump was keeping in sync. I stopped the replicat while i was pumping the inital load.

The inital load was from sourceistable and it pumped fine or appeared to. I got several million records pumped across. On the replicat side I get "No active replication maps."

--
-- DATA PUMP parameter file to read local
-- trail of ebis changes.
--
EXTRACT EPMPDP
PASSTHRU
RMTHOST dserver, MGRPORT 7809
RMTTRAIL s:\goldengate\dirdat\lb
TABLE ebis.BAR_AAA_DB_REC;
TABLE ebis.BAR_CTY_DB_REC;
TABLE ebis.DNR_VST_DB_REC;
~

inital load parm file
--
-- GoldenGate Inital Data Capture
-- for ebis schema
--
EXTRACT EINIWH
USERID user, PASSWORD password
RMTHOST dserver.win2k.cfbb.org, MGRPORT 7809
RMTTASK REPLICAT, GROUP RINIEB
TABLE EBIS.DNR_VST_DB_REC;
~

Replicat

replicat DELEBIS
sourcedb datawarehouse
sourcedefs s:\goldengate\dirdef\jims.def
HANDLECOLLISIONS
discardfile s:\goldengate\dirrpt\DELEBIS.dsc, purge
MAP ebis.BAR_AAA_DB_REC, TARGET dbo.BAR_AAA_DB_REC;
MAP ebis.BAR_CTY_DB_REC, TARGET dbo.BAR_CTY_DB_REC;
MAP ebis.DNR_VST_DB_REC, TARGET dbo.DNR_VST_DB_REC;

Thank you for any help.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 3 2012
Added on Jan 6 2012
3 comments
7,162 views