Home
About
Contact
Subscribe
Oracle Application DBA
Toggle navigation
Community
Oracle DBA
Apps DBA
Sev1
Post Error
Facebook Groups
Jobs
Oracle DBA
Apps DBA
Err Soln
Scripts
Database
Apps
Crontab
RMAN Scripts
Issues
IMPLINKS
Submit
R12.2 Apps DBA. Powered by
Blogger
.
DB Link Between Two Databases in Oracle APPS
12c
,
AppsDBA
,
Oracle DBA
,
R12.2
No comments :
The name of the db link is 'dev_db'.
CREATE PUBLIC DATABASE LINK
dev_db
CONNECT TO
apps
IDENTIFIED BY
apps
USING 'HOST:PORT/SID';
Example:
INSERT INTO xx_emp_table@dev_db
SELECT *
FROM xx_emp_table;
Tweet
No comments :
Post a Comment
Note: only a member of this blog may post a comment.
Subscribe to:
Post Comments ( Atom )
Live Traffic Stats
Blog Archive
►
2017
( 2 )
►
January
( 2 )
►
2016
( 160 )
►
December
( 52 )
►
October
( 21 )
►
September
( 9 )
►
February
( 22 )
►
January
( 56 )
▼
2015
( 145 )
▼
December
( 58 )
Collecting adop and fs_clone log files R12.2
ASM Scripts
start CD 12.2.0.48 with R12.2 Stage
adop an error occurred while generating Oracle For...
adop prepare phase failed on master node
Post cutover patching failed
Upgrade Oracle EBS R12.2.0 to R12.2.4
How To Change The Web Port in E-Business Suite R12...
adop phase=cleanup Failed
R12.2 Installation and upgrade to 12.2.4
SOA Installation and Configuration Oracle R12.2.4
Unable to Run a specific Control R12.2
EBS Post Clone SSL SSO steps
R12.2 Real time Cloning Procedure
R12.2 fs_clone fails with ERROR: Number of servers...
Adop Prepare Failure With Error ORA-12521 R12.2
Useful Scripts for ADOP Session R12.2
java.lang.OutOfMemoryError: Java heap space
Oracle Apps R12.2 OS ENVIRONMENT VARIABLES And LOGS
FORM Compilation Steps in Oracle APPS
Find Oracle APPS User Password From Backend
Submit a Concurrent Program/Request from PL/SQL
How to change Concurrent Request View output to vi...
DB Link Between Two Databases in Oracle APPS
Query to find the Concurrent Request Trace File Path
Oracle Apps: Check file version
How Do You Access An Indirect Responsibilty When T...
Cause: Application Object Library was unable to lo...
FS clone cannot be called while a patching cycle i...
fs_clone failed report BIOJLZZTVSR.rdf to patch fs...
ADOP Failed With "phase=fs_clone" ERROR: Failed to...
R12.2 adop fs_clone Fails with ORA-00936: missing ...
Run the following script to determine the number/t...
Adop Phase=fs_clone Failing on TxkADOPPreparePhase...
Adop Phase=fs_clone Failed With Error There Is A P...
adop phase=fs_clone error: ERRORMSG: Not enough sp...
ORA-20041 ORA-20002 R12.2
adop phase=abort continues to error
How to change Concurrent Request View output to vi...
DB Link Between Two Databases in Oracle APPS
Kill Current Session and Update Concurrent Program...
How to Add Responsibility to User from Back-end in...
How To Trace a Concurrent Request And Generate TKP...
REP-56093:File:Cached Output For Job 1 is No Longe...
Bad Gateway. Request could not be processed. Inval...
REP-3000: Internal error starting Oracle Toolkit f...
How to build a new Central Inventory for 12.2
TNS-12560
frm-92101 12.2
How to compile fmb or form 12.2
RC-50208 adcfgclone fmw_home/webtier not created 12.2
How to restart Sendmail services on linux server
java.lang.OutOfMemoryError in R12.2
How To Change Home Page For R12.2
How To Create DBA Directories
Troubleshooting Oracle Apps DBA Scripts
Error with NodeManager and Weblogic Server
Oracle Apps CLONING Scripts
►
November
( 69 )
►
October
( 18 )
Labels
12c
ADOP
Apache
Apex
AppsDBA
ASM
CM
Data Guard
Dataguard
DB links
Linux
MSCA/MWA
Oracle DBA
R12.2
RAC
RMAN
Severity 1
SOA
SSO
UNIX
Weblogic
WF
No comments :
Post a Comment
Note: only a member of this blog may post a comment.