Re: impdp interval partitions

 Mark
Thanks for the update. Can you please provide an example ? I had around 50 partitions that I had to move from Database A to Database B before dropping them from Database A. Expdp was taken for all these partition in a chunk of 15-20 partition in each dump. I can import the table as TABLEB in Database B and can do some exchange to TABLEA in Database B but not sure if Exchange is allowed or need to create non-partition intermediate table. Any small example can be helpful. Thanks for your time
Sanjay

    On Tuesday, October 26, 2021, 12:03:20 PM EDT, Mark W. Farnham <mwf_at_rsiz.com> wrote:  

 <!--#yiv5893706230 _filtered {} _filtered {}#yiv5893706230 #yiv5893706230 p.yiv5893706230MsoNormal, #yiv5893706230 li.yiv5893706230MsoNormal, #yiv5893706230 div.yiv5893706230MsoNormal {margin:0in;margin-bottom:.0001pt;font-size:12.0pt;font-family:"Times New Roman", "serif";}#yiv5893706230 a:link, #yiv5893706230 span.yiv5893706230MsoHyperlink {color:blue;text-decoration:underline;}#yiv5893706230 a:visited, #yiv5893706230 span.yiv5893706230MsoHyperlinkFollowed {color:purple;text-decoration:underline;}#yiv5893706230 p.yiv5893706230ydp4f5966d6msonormal, #yiv5893706230 li.yiv5893706230ydp4f5966d6msonormal, #yiv5893706230 div.yiv5893706230ydp4f5966d6msonormal {margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:"Times New Roman", "serif";}#yiv5893706230 p.yiv5893706230ydp89b4997cmsonormal, #yiv5893706230 li.yiv5893706230ydp89b4997cmsonormal, #yiv5893706230 div.yiv5893706230ydp89b4997cmsonormal {margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:"Times New Roman", "serif";}#yiv5893706230 span.yiv5893706230EmailStyle19 {font-family:"Calibri", "sans-serif";color:#1F497D;}#yiv5893706230 .yiv5893706230MsoChpDefault {font-size:10.0pt;} _filtered {}#yiv5893706230 div.yiv5893706230WordSection1 {}--> 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