Database Utilities (MOSC)

MOSC Banner

impdp question

edited Aug 30, 2013 5:21AM in Database Utilities (MOSC) 6 commentsAnswered
Hi Everyone,
I have within one database two schemas, A, and B.
B.claim_0829 is a copy of a.claim,
The claim table is partitioned by year, and subpartitioned by payer like 1990_BCBS, THCP, etc.
What I need to do is to use last week's export of A.claim dump, and only to overwrite B.claim_0829 by one partition.
Here is the partial list of the subpartition and partition names:
......
CLAIM_2002_BCBS                CLAIM_2002
CLAIM_2002_DEF                 CLAIM_2002
CLAIM_2002_HPHC                CLAIM_2002
CLAIM_2002_NHP                 CLAIM_2002
CLAIM_2002_THP                 CLAIM_2002
CLAIM_2003_BCBS                CLAIM_2003
CLAIM_2003_DEF                 CLAIM_2003
CLAIM_2003_HPHC                CLAIM_2003
CLAIM_2003_NHP                 CLAIM_2003
CLAIM_2003_THP                 CLAIM_2003

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center