CODE
Oracle Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
PSOUG Home Code Snippets Oracle Reference Oracle Functions PSOUG Forum Oracle Blogs Bookmark and Share
 
 Search the Reference Library pages:  

Free
Oracle Magazine
Subscriptions
and Oracle White Papers

Oracle DBMS_DBLINK
Version 11.1
 
General
Source $ORACLE_HOME/rdbms/admin/dbmslink.sql
Dependencies
DBMS_DBLINK_LIB
Security Model Can be executed only by a SYSDBA: Granted to execute_catalog_role
 
UPGRADE
Upgrades all database links, this will simply execute the DDL as the owner of the database link. This needs to be in the migrate mode
and the current user executing this should be SYSDBA user.
dbms_dblink.upgrade;
exec dbms_dblink.upgrade;
 
 
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us [64 users online]    © 2010 psoug.org