impdp question
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
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
0