impdp interval partitions
Date: Tue, 26 Oct 2021 14:51:16 +0000 (UTC)
Message-ID: <367198200.1142662.1635259876882_at_mail.yahoo.com>
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 TIASanjay
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Oct 26 2021 - 16:51:16 CEST