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@xxxxxxxxxxxxx> 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@xxxxxxxx> 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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On ;
Behalf Of Sanjay Mishra ("smishra_97")
Sent: Tuesday, October 26, 2021 10:51 AM
To: oracle-l@xxxxxxxxxxxxx
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