ORA-02019 DURING REMOTE INSERT WITH A LOCAL SEQUENCE
(Doc ID 130206.1)
Last updated on FEBRUARY 18, 2020
Applies to:Oracle Database - Enterprise Edition - Version 220.127.116.11 to 10.2.0.4 [Release 8.1.7 to 10.2]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.
In your TNSNAMES.ORA you have:
(ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xx.xxx.xx )(PORT = 1521))
(SERVICE_NAME = lb1)
you create the database link:
create database link LB1
connect to scott
identified by tiger
You create local sequence:
create sequence rl1
increment by 1
start with 1
SQL> insert into emp@lb1 (empno) values (rl1.nextval) ;
insert into emp@lb1 (empno) values (rl1.nextval)
ERROR at line 1:
ORA-02019: connection description for remote database not found
ORA-02063: preceding line from LB1
The database link seems to be working fine.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document