RE: impdp interval partitions

Rather than me building an example and spoon feeding it to you, I suggest you find a copy of “Scaling to Infinity” by Tim Gorman. I believe that is the clearest explanation of partition exchange done well and any re-write I would do would probably be flawed by comparison.  

Anyone who has anything big enough or hot enough to partition should read Tim’s entire paper, and since he improved it over time and included new features as needed, finding the most recent vintage is worthwhile.  

Enjoy! This will be enlightening.  

From: Sanjay Mishra [mailto:smishra_97_at_yahoo.com] Sent: Tuesday, October 26, 2021 1:45 PM
To: oracle-l_at_freelists.org; Mark W. Farnham Subject: 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:    

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