Oracle provides database links to create direct connections from one database instance to another. This feature can come in handy in the movement of small to moderate amounts of data between systems. In this article we will review the creation of the DDL to regenerate public database links defined within an Oracle database.
1. [...]
ReliDB
Oracle tips and tricks.
Posts tagged dba_db_links
Recreating Oracle Public Database Link
Categories
- 11g
- ASM
- audit
- hp-ux
- installer
- itanium
- linux
- listener
- network
- OPatch
- Oracle
- Oracle 10g
- oracle 9i
- privileges
- RAC
- script
- security
- SQL
- sqlplus
- uncategorized
- unix
- windows
- windows 7
Tags
- Add new tag
- audit
- auditing
- change
- connection
- create
- database
- dba
- ddl
- delete
- display
- environment
- file
- find
- hp-ux
- linux
- listener
- move
- movement
- network
- OPatch
- Oracle
- os
- password
- pl/sql
- privilege
- privileges
- profile
- RAC
- recovery
- recreate
- remove
- RMAN
- role
- setup
- shell
- SQL
- sqlplus
- sysdba
- tablespace
- trace
- unix
- user
- utl_file
- variables
Archives
Recent Posts
- Oracle installation of 10.2.0.4 for Windows 7 Error
- Enable ADMIN Tracing on Oracle Listener:
- Oracle UTL_RECOMP package and the RECOMP_SERIAL subprogram
- Oracle UTL_RECOMP package and the RECOMP_PARALLEL subprogram
- Oracle - Encoding and Decoding Oracle data with UTL_ENCODE Package
Popular Posts
- Oracle UTL_RECOMP package and the RECOMP_SERIAL subprogram (2)
- Listener Configuration on HP-UX Itanium Server: HPUX Error: 239: Connection refused (1)
- Determination of Components installed on your Oracle RDBMS. (1)
- OPatch platform id 46-linux not 59-hpux: Code 73 (1)
- OPatch apply lib .so file not writable: Code 73 (1)
- Oracle - Profile for single User owning multiple databases with Single (1)
- Multiple TNSNAMES alias for single database: (1)
- Oracle - Determining Local Host name and IP address with UTL_INADDR procedure (1)