Technical Notes
We're all on the same page!
Showing posts with label
database link
.
Show all posts
Showing posts with label
database link
.
Show all posts
Friday, 12 January 2018
enq: JI - contention wait event solution
›
Action Synchronizing data with remote database( NEW_XE ) SQL> BEGIN DBMS_SNAPSHOT.REFRESH(LIST => 'HR.SS_EMPLOYEES_NEW',M...
Wednesday, 21 September 2016
How to use existed tns connection for new one?
›
* The key point is 'Using' keyword that checks tnsnames.ora connection node then you can reach remote database. SQL> CREATE D...
Tuesday, 13 September 2016
How to define new db link?
›
Add a new connection node into tnsnames.ora file. vi $ORACLE_HOME/network/admin/tnsnames.ora e.g. ALPER_DB = (DESCRIPTION = (...
Wednesday, 15 October 2014
How to check database link?
›
SQL> SELECT 1 FROM dual@ mydblink
›
Home
View web version