Pages

Monday, August 30, 2010

Important File Paths for DB and APPS - 1

Some very basic file paths for oracle applications daily trouble shooting and user requirements are listed below. At some places this paths may vary according to environments, but the basic location will be similar.
 Context Files: 
  • This is one of the most important files, to make the application work.

Saturday, August 28, 2010

DB Links

DB Links or Database Links are used to connect mainly one database to another. It may be used to point to same database in some cases.
The information related to DB Link can be found from "DBA_DB_LINKS".

The syntax for db links is
SQL> Create [PUBLIC] database link "<Link_name>"
        connect to <remote_dbuser> identified by <remoteuser_pasword>
        using '<host>';