Oracle EXCHANGE
Version 26ai

General Information
Library Note Morgan's Library Page Header
The best Oracle News for FY2026

Oracle Database 26ai is now availble. If you haven't you downloaded already: Why?
Purpose According to the Oracle docs, this package is owned by the Global Data Services schema. It should not be unlocked or used for a database login.
AUTHID CURRENT_USER
Data Types TYPE d_type ...

TYPE p_type ...
Dependencies
CHUNKDATA_TMP DBMS_PARALLEL_EXECUTE KU$_MULTI_DDL
DBMS_ASSERT DBMS_PLUGTS KU$_MULTI_DDLS
DBMS_GSM_COMMON DBMS_SQL KU$_PARSED_ITEM
DBMS_GSM_DBADMIN DBMS_STANDARD KU$_PARSED_ITEMS
DBMS_GSM_UTILITY DBMS_SYS_ERROR KU$_VCNT
DBMS_LOB DBMS_UTILITY MOVE_DATA
DBMS_METADATA KU$_DDL PLITBLM
DBMS_OUTPUT KU$_DDLS  
Documented No
First Available 19c
Security Model Owned by GSMADMIN_INTERNAL with no privileges granted.

Direct access to this package is prevented by an Accessible By clause.
Source {ORACLE_HOME}/rdbms/admin/prvtgwmco.plb
Subprograms
 
DO_DDL_JOB
Undocumented exchange.do_ddl_job(
fromid      IN NUMBER,
toid        IN NUMBER,
chunk_id    IN NUMBER,
operation   IN VARCHAR2,
obj_type    IN VARCHAR2,
doexec      IN BOOLEAN,
ignor_error IN BOOLEAN,
inguid      IN VARCHAR2,
seq         IN NUMBER);
TBD
 
EXCHANGE_IN
Undocumented exchange.exchange_in(
tablespace_list IN VARCHAR2,
db_link         IN VARCHAR2,
doexec          IN BOOLEAN,
test_mode       IN NUMBER
new_datafiles   IN gsmadmin_internal.exchange.d_type);
TBD
 
EXCHANGE_OUT
Undocumented exchange.exchange_out(
tablespace_list IN VARCHAR2,
new_tablespace  IN gsmadmin_internal.exchange.p_type,
doexec          IN BOOLEAN;
TBD
 
PRELOAD
Undocumented

Protected by ACCESSIBLE BY clause
exchange.preload(
tbs_list IN VARCHAR2,
db_link  IN VARCHAR2);
exec gsmadmin_internal.exchange.preload('UWDATA', 'SYS.REMOTE');
     *
PLS-00904: insufficient privilege to access object EXCHANGE

Related Topics
Built-in Functions
Built-in Packages
Database Security
DBMS_GSM_ALERTS
DBMS_GSM_COMMON
DBMS_GSM_DBADMIN
DBMS_GSM_FIX
DBMS_GSM_FIXED
DBMS_GSM_NOPRIV
DBMS_GSM_POOLADMIN
DBMS_GSM_UTILITY
DBMS_GSM_XDB
What's New In 21c
What's New In 26ai

Morgan's Library Page Footer
This site is maintained by Daniel Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2026 Daniel A. Morgan All Rights Reserved