| 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. |
| AUTHID |
DEFINER |
| Dependencies |
|
| Security Model |
Owned by SYS with EXECUTE granted to the EXECUTE_CATALOG_ROLE role only |
| Source |
$ORACLE_HOME/rdbms/admin/dbmslink.sql |
| |
| 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; |