Archive to individual tables per interval and use partition exchange.
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On ;
Behalf Of Sanjay Mishra ("smishra_97")
Sent: Tuesday, October 26, 2021 10:51 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: impdp interval partitions
Can someone help as how to import partition data into existing partition table
created to archive old partition from another database? I took the backup of
multiple partitions from Source but getting error while importing as partition
do not exist as target table like source is also Interval partitioned. I am
using TABLE_EXISTS_ACTION=APPEND and cannot manually add partition in target as
it is Interval Partitioned table
Following error coming
ORA-31693: Table data object "SCHEMA"."TABLE":"Partition1" failed to
load/unload and is being skipped due to error:
ORA-02149: Specified partition does not exist
Options used
remap_schema=Schema1:Schema2
EXCLUDE=CONSTRAINT,STATISTICS,INDEX
TRANSFORM=DISABLE_ARCHIVE_LOGGING:Y
TABLE_EXISTS_ACTION=APPEND
DATA_OPTIONS=TRUST_EXISTING_TABLE_PARTITIONS
TIA
Sanjay