Re: impdp interval partitions

 Mark
I changed the Partition to Range and added the required blank partition and ran the impdp to load the data. Later changed the partition back to Interval and so is good. TxSanjay

    On Tuesday, October 26, 2021, 01:45:26 PM EDT, Sanjay Mishra <dmarc-noreply_at_freelists.org> wrote:  

  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:  

 <!--#yiv6380969169 filtered {}#yiv6380969169 filtered {}#yiv6380969169 p.yiv6380969169MsoNormal, #yiv6380969169 li.yiv6380969169MsoNormal, #yiv6380969169 div.yiv6380969169MsoNormal {margin:0in;margin-bottom:.0001pt;font-size:12.0pt;font-family:"Times New Roman", "serif";}#yiv6380969169 a:link, #yiv6380969169 span.yiv6380969169MsoHyperlink {color:blue;text-decoration:underline;}#yiv6380969169 a:visited, #yiv6380969169 span.yiv6380969169MsoHyperlinkFollowed {color:purple;text-decoration:underline;}#yiv6380969169 p.yiv6380969169ydp4f5966d6msonormal, #yiv6380969169 li.yiv6380969169ydp4f5966d6msonormal, #yiv6380969169 div.yiv6380969169ydp4f5966d6msonormal {margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:"Times New Roman", "serif";}#yiv6380969169 p.yiv6380969169ydp89b4997cmsonormal, #yiv6380969169 li.yiv6380969169ydp89b4997cmsonormal, #yiv6380969169 div.yiv6380969169ydp89b4997cmsonormal {margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:"Times New Roman", "serif";}#yiv6380969169 span.yiv6380969169EmailStyle19 {font-family:"Calibri", "sans-serif";color:#1F497D;}#yiv6380969169 .yiv6380969169MsoChpDefault {font-size:10.0pt;}#yiv6380969169 filtered {}#yiv6380969169 div.yiv6380969169WordSection1 {}--> 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