| General Information |
| Purpose |
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. |
| Source |
$ORACLE_HOME/rdbms/admin/dbmslink.sql |
| Dependencies |
|
| Security Model |
Can be executed only by a SYSDBA: Granted to the EXECUTE_CATALOG_ROLE 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; |
