admin管理员组文章数量:1330590
We are migrating from 11g to 19c version. But we want to test if we can trasnfer a specific column from 11g to 19c upon insert.
Is there a possible way to connect Oracle11g and Oracle19c databases?
The scenario is Oracle11g Table1 transfer specific columns of data to Oracle19c Table2. Same column structure for both tables.
For example:
FROM
Oracle11g
PRODUCT
Product_name | product_description |
---|---|
Bolt | Metal |
Ziptie | Plastic |
We are migrating from 11g to 19c version. But we want to test if we can trasnfer a specific column from 11g to 19c upon insert.
Is there a possible way to connect Oracle11g and Oracle19c databases?
The scenario is Oracle11g Table1 transfer specific columns of data to Oracle19c Table2. Same column structure for both tables.
For example:
FROM
Oracle11g
PRODUCT
Product_name | product_description |
---|---|
Bolt | Metal |
Ziptie | Plastic |
SUPPLIER
Product_name | Supplier |
---|---|
Bolt | Home Depot |
Ziptie | Plastic |
TO
Oracle19c
PRODUCT WAREHOUSE
Product_name | product_description | Supplier |
---|---|---|
Bolt | metal | Home Depot |
Ziptie | plastic | Home Depot |
- 2 What have you tried? It sounds like you just want a database link. – Justin Cave Commented Dec 2, 2024 at 19:05
- Yes, 11.2.0.3 and up should be able to connect to 19c. Try it first, then ask if you get stuck. – Paul W Commented Dec 2, 2024 at 19:52
- yes I only want a database link but I can't find any tuotrials on google they just redirect me to migration – Ian Commented Dec 3, 2024 at 0:00
- Update on this I found a video. its just a simple creation of datalink and I already tested it. Thanks for everyone who commented. – Ian Commented Dec 3, 2024 at 1:38
1 Answer
Reset to default 1Yes, you can create a database link:
Documentation: https://docs.oracle/cd/E11882_01/server.112/e41084/statements_5005.htm
Source: DB 11g
Target: DB 19c
So:
1 - On the source you need ro create a user to dblink connection.
2 - On the target you need to create an entry in tnsnames.ora
pointing to rhe 11g connection.
3 - On target 19c create dblink pointing to 11g database:
CREATE DATABASE LINK oracle11g_link CONNECT TO username IDENTIFIED BY password USING 'oracle11g_tns_entry';
4 - Insert Data using dblink:
CREATE TABLE test AS
SELECT *
FROM PRODUCT@oracle11g_link;
OR
You can use Datapump to export/import the data:
On source:
#If you choose export entire schema:
expdp \"/ as sysdba\" schemas=SCHEMANAME dumpfile=test.dmp
#If you choose export just one or more tables:
expdp \"/ as sysdba\" tables=SCHEMANAME.TABLENAME dumpfile=test.dmp
Wait export complete and copy the dumpfile to targer server (19c):
On Target:
impdp \"/ as sysdba\" dumpfile=test.dmp
本文标签: oracle11gLink Oracle 11g and Oracle 19c databaseStack Overflow
版权声明:本文标题:oracle11g - Link Oracle 11g and Oracle 19c database? - Stack Overflow 内容由网友自发贡献,该文观点仅代表作者本人, 转载请联系作者并注明出处:http://www.betaflare.com/web/1742251516a2440851.html, 本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容,一经查实,本站将立刻删除。
发表评论