RE: impdp interval partitions

Archive to individual tables per interval and use partition exchange.  

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Sanjay Mishra ("smishra_97") Sent: Tuesday, October 26, 2021 10:51 AM To: oracle-l_at_freelists.org
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  

--
http://www.freelists.org/webpage/oracle-l