oracle11g - Link Oracle 11g and Oracle 19c database? - Stack Overflow

admin管理员组

文章数量:1331875

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

• oracle-database
• oracle11g
• oracle19c

Share Improve this question Follow edited Feb 10 at 4:29 Dale K 27.5k1515 gold badges5858 silver badges8383 bronze badges asked Dec 2, 2024 at 18:41 IanIan 311 silver badge44 bronze badges 4

• 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

Add a comment  | 

1 Answer 1

Sorted by: Reset to default 1

Yes, 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