Insert data into SYSTEM partitioned table using DB link [message #655415] |
Tue, 30 August 2016 15:05 |
anil_mk
Messages: 146 Registered: August 2006 Location: Bangalore, India
|
Senior Member |
|
|
Hi All,
I have 2 Oracle databases SRC_DB and TGT_DB, there is DB link DB_LINK1 created at SRC_DB database to point to TGT_DB.
--Run below code in SRC_DB database
CREATE TABLE syspart (c1 NUMBER, c2 NUMBER)
PARTITION BY SYSTEM (
PARTITION APAC_REGION ,
PARTITION AMERICA_REGION,
PARTITION EMEA_region
);
INSERT INTO SYSPART PARTITION(APAC_REGION) VALUES (1, 2);
INSERT INTO SYSPART PARTITION (AMERICA_REGION) VALUES (3, 4);
commit;
Run below table create script in TGT_DB
CREATE TABLE syspart (c1 NUMBER, c2 NUMBER)
PARTITION BY SYSTEM (
PARTITION APAC_REGION ,
PARTITION AMERICA_REGION,
PARTITION EMEA_region
);
Now I want to transfer data from SRC_DB to TGT_DB, I tried below INSERT statement but its failing
Run below INSERT statement in SRC_DB
INSERT INTO SYSPART@DB_LINK1 PARTITION(APAC_REGION) SELECT * FROM SYSPART;
COMMIT;
I am getting below error
[Error] Execution (12: 23): ORA-14100: partition extended table name cannot refer to a remote object
Please help me how to INSERT data from system partitioned table data into another system partitioned table(Different DB) of same table structure using DB link .
Thanks
|
|
|
|
|
|
|