Oracle DBMS_GSM_DBADMIN
Version 26ai

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

Oracle Database 26ai will be available on generic Linux platforms in January and soon on AIX and Windows
Purpose Global Service Manager Administration.

There is a lot of fascinating new capability hinted at in this package. Take a close look at the constants and the dependencies.
AUTHID DEFINER
Constants
Name Data Type Value
RAC Status Values
GWM_NORAC (not RAC) PLS_INTEGER 0
GWM_RAC_ADMIN
(admin managed RAC)		 PLS_INTEGER 1
GWM_RAC_POLICY
(policy managed RAC)		 PLS_INTEGER 2
GWM_RAC_UNKNOWN
(unknown RAC status)		 PLS_INTEGER 3
GWM_RAC_SIHA (RAC SIHA) PLS_INTEGER 4
Data Types TYPE target IS RECORD(db_name VARCHAR2(dbms_gsm_common.max_ident),
conn_id VARCHAR2(512),
role    VARCHAR2(30),
dblink  VARCHAR2(256),
jobid   NUMBER);

TYPE target_set IS TABLE OF target;

TYPE chunk_list_t IS TABLE OF NUMBER index by PLS_INTEGER;
Dependencies SELECT name FROM dba_dependencies WHERE referenced_name = 'DBMS_GSM_DBADMIN' UNION
SELECT referenced_name FROM dba_dependencies WHERE name = 'DBMS_GSM_DBADMIN' ORDER BY 1;

Returns 144 objects
Documented No
First Available 12.1
Security Model Owned by GSMADMIN_INTERNAL with EXECUTE granted to GGSYS, GSMROOTUSER_ROLE, and GSMUSER_ROLE
Source {ORACLE_HOME}/rdbms/admin/dbmsgwmdb.sql
Subprograms
ADDDATABASE GETREPLTYPE SETDFLTLOBTBLSPCREMOTE
ADDGSM GETSHARDINGMETHOD SETDFLTPTNTBLSPC
ADDREGION GETSHARDSPACEBYTS SETDFLTPTNTBLSPCREMOTE
ADDSERVICE GETSHARDSPACEIDBYPSET SETPARAMETER
ADJUST_LOBOUNDS GETSHARDSPACEIDBYTS SETRATABLEFAMILY
ADJUST_LOBOUNDS_TMPPSET GETSSCHUNKNUMBERS SETREMOTECHUNKSTATE
ALTAB_ADDPSET GETTARGETDBCONNSTR SETSPLITPSETSTATUS
ALTAB_ADDPSET_REMOTE GETTARGETDBNAME SETSTBYPARAM
ALTAB_LOCAL_ADDPSET GETTARGETDBSBYSSID SETUPMETADATACURSOR
ALTAB_UPDPSET GETTSSETBYTBLSPACE SETUPRU
ALTAB_UPDSHTS GET_CLONE_STATUS SETUPSESSIONCONTEXT
ALTERALLREFFRAGMENTSUNITTEST GRABCHUNKSFROMCATALOG SNRDONEBARDDL
ATPPUT IMPORTDATA SNRSENDDDLCOMPLLCR
ATPVALIDATE IMPORTDATA2 SNRSYNCPOINT
CHECKDDLSTATUS INITIATEDDLSTATUS SNRUPDATERUCMPLID
CHECKSNRBARRIER INSSPSMON SPLITCHUNK
CHUNKSTATEEXISTS INSSTARTCHUNKSPLITPSETSTAT SPLITPSETFILLCATTSSETTBL
CLEANTARGET INSTSCHUNKSPLITPSETSTAT SPLITPSETFILLTSSETTBL
CLEANTARGETREMOTE ISCATBARDDL SPLITPSETPKPOSTPROC
CONFIGOGGREPLICATION ISCATDDLCOMPLETE SPLITPSETPOSTPROCREMOTE
CONTROLCHUNK ISINDDLCATCHUP SPLITPSETTBLPOSTPROC
CONTROLREMOTECHUNK LEAVERU SPLITPSETTBLSPCPOSTPROC
CREATEAPPLYSTARTRU LOAD_CAT_QP_DATA SPLIT_PSET_FINISH_CAT
CREATENEWRU MODIFYDATABASE SPLIT_PSET_RMDBLINK
CREATERATABLEFAMILY MODIFYGSM SPSLOGCNTTGTCHUNKS
CREATESHARDDBLINK MODIFYREGION SPSLOGINRECOVERY
CREATE_APPLY MODIFYSERVICE SPSLOGISCOMPLETE
DO_DDL_JOB_WRAPPER MODIFYSERVICEGLOBALPARAMETERS SPSLOGLASTSRCCHUNK
DROPRATABLEFAMILY MODIFYSERVICELOCALPARAMETERS SPSLOGLASTTGTCHUNK
DROP_APPLY MOVECHUNK SPSLOGMARKCOMPLETE
ENSUREDBLINK MOVELOGFILES SPSLOGPARTCOMPLETE
ENSURE_REMOTE_CONN MOVERU SPSLOGPARTWRITE
EXECUTEDDLCALLBACK PDBADD_SERVICE SPSLOGRECOVERYSTATE
EXECUTEDDLPRVT PDBMODIFY_SERVICE SPSLOGSRCCHUNKSTATE
EXECUTEGENERICPROCEDURE PREPAREMETADATALOCAL SPSLOGTRUNCATE
EXPORTMETADATA PREPAREMETADATAREMOTE SPSLOGWRITE
FETCHEXECDDLSFROMCATALOG PROPAGATERUROLE SSIDTSEXISTS
FINISHMOVE PSEXISTS STARTRUELECTION
GENERATE_TABLESPACE_NAME PTSHDBUILDALLOWEDSCHEMAS STARTSERVICE
GETBHIBNDVAL PTSHDBUILDINCLEXPR STOPRU
GETCATDDLSTATUSCNT PTSHDFILTEROBJECTS STOPSERVICE
GETCONNSTRBYCONTAINER PTSHDMATCHOBJTYPE STRTOLIST
GETCRSINFO PTSHDVALIDATEDEPENDENCY SYNC
GETCURCATDDLID RBLDALLINDEXES SYNCALLRUPARAMS
GETDATATABLESPACE RBLDINDEXES SYNCCOMPATIBLE
GETDBBYCHUNKSSID RECOVERCHUNKS SYNCDDLPARAMETER
GETDBLINKNAME RECOVERSHARDDDLCLONE SYNCRU
GETDBNUMBERRANGE RELOCATECHUNKSRU TABEXISTS
GETENCPWD REMOVEALLSERVICES TMP_ADDPSET
GETFAMILYTABNAMES REMOVEDATABASE TSEXISTS
GETGSMINFO REMOVEGSM UPDATECATDDLSTATUS
GETHIBNDVAL REMOVEREGION UPDATEDDLSTATUS
GETHOSTINFO REMOVERU UPDATEMETADATADISTRIB
GETKNCLPCAPCURVSN REMOVESERVICE UPDATESHDDDLSTATUS
GETLATESTDDLID RENAME_PSET UPDENDCHUNKSPLITPSETSTAT
GETLOBTABLESPACE REPLACERUPEER UPDSPSMONBACKUP0
GETLOBTSCOUNT RESTORECHUNK UPDSPSMONBACKUP1
GETLOCALCHUNKNUMBERS SCHEDULENOWRBLDALL UPDSPSMONCOMPLETE
GETLOCALPENDINGCHUNKNUMBERS SEND_GDSCTL_MSG UPDSPSMONIMPORT
GETLOCALSHARDSPACEID SETCATALOGLINK UPDSPSMONTRANSFER0
GETMAXSTARTCATDDLID SETCHUNKS UPDSPSMONTRANSFER1
GETOBJECTID SETCHUNKSTATE UPDTSCHUNKSPLITPSETSTAT
GETREMOTECONNSTR SETDDLTIMEOUT VALIDATEDATABASE
GETREMOTEENCSECRET SETDFLTLOBTBLSPC VALIDATENATIVEREPLICATION
GETREMOTEROWCOUNT    
 
ADDDATABASE
Adds a database to the GDS (Cloud) framework

Overload 1		 dbms_gsm_dbadmin.addDatabase(
cloud_name             IN VARCHAR2,
dbpool_name            IN VARCHAR2,
region_name            IN VARCHAR2,
db_number              IN NUMBER,
num_instances_reserved IN NUMBER DEFAULT dbms_gsm_common.max_inst_default,
force                  IN NUMBER DEFAULT dbms_gsm_common.isFalse,
cpu_thresh             IN NUMBER DEFAULT NULL,
srlat_thresh           IN NUMBER DEFAULT NULL,
inShard                IN NUMBER DEFAULT dbms_gsm_common.isFalse,
chunks                 IN NUMBER DEFAULT 0);
TBD
Overload 2 dbms_gsm_dbadmin.addDatabase(dsc IN database_dsc_t);
TBD
 
ADDGSM
Informs the database of a new GSM added to the catalog dbms_gsm_dbadmin.addGSM(
gsm_alias   IN VARCHAR2,
endpoint    IN VARCHAR2,
region_name IN VARCHAR2,
ons_port    IN NUMBER);
TBD
 
ADDREGION
Inform the database of a new region in the catalog dbms_gsm_dbadmin.addRegion(
region_name  IN VARCHAR2,
buddy_region IN VARCHAR2 DEFAULT NULL);
TBD
 
ADDSERVICE
Creates a new global service in the database and CRS dbms_gsm_dbadmin.addService(
service_name              IN  VARCHAR2,
network_name              IN  VARCHAR2,
rlb_goal                  IN  NUMBER   DEFAULT NULL,
clb_goal                  IN  NUMBER   DEFAULT NULL,
distr_trans               IN  NUMBER   DEFAULT NULL,
aq_notifications          IN  NUMBER   DEFAULT NULL,
aq_ha_notifications       IN  NUMBER   DEFAULT NULL,
lag_property              IN  NUMBER   DEFAULT NULL,
max_lag_value             IN  NUMBER   DEFAULT NULL,
failover_method           IN  VARCHAR2 DEFAULT NULL,
failover_type             IN  VARCHAR2 DEFAULT NULL,
failover_retries          IN  NUMBER   DEFAULT NULL,
failover_delay            IN  NUMBER   DEFAULT NULL,
edition                   IN  VARCHAR2 DEFAULT NULL,
pdb                       IN  VARCHAR2 DEFAULT NULL,
commit_outcome            IN  NUMBER   DEFAULT NULL,
retention_timeout         IN  NUMBER   DEFAULT NULL,
replay_initiation_timeout IN  NUMBER   DEFAULT NULL,
session_state_consistency IN  VARCHAR2 DEFAULT NULL,
sql_translation_profile   IN  VARCHAR2 DEFAULT NULL,
locality                  IN  NUMBER   DEFAULT NULL,
region_failover           IN  NUMBER   DEFAULT NULL,
role                      IN  NUMBER   DEFAULT NULL,
proxy_db                  IN  NUMBER   DEFAULT 0,
primary_db                OUT NUMBER);
DECLARE
 serv_name VARCHAR2(30) := 'MLIBSERV';
 netw_name VARCHAR2(30) := 'MLIBNET';
 rlb_goal  NUMBER := dbms_service.goal_service_time;
 clb_goal  NUMBER := dbms_service.clb_goal_short;
 dist_trx  NUMBER := 0;
 aq_notif  NUMBER;
 aq_ha     NUMBER := 1;
 lag_prop  NUMBER;
 max_lagv  NUMBER;
 fail_meth VARCHAR2(6) := dbms_service.failover_method_basic;
 fail_type VARCHAR2(30) := 'TRANSACTION';
 fail_retr NUMBER := 3;
 faildelay NUMBER := 5;
 ed_name   VARCHAR2(30) := 'ORA$BASE';
 pdb       VARCHAR2(30) := NULL;
 commit_oc NUMBER := 1;
 retent_to NUMBER := 86400;
 replay_it NUMBER := 900;
 ses_state VARCHAR2(30);
 sql_trans VARCHAR2(30);
 locality  NUMBER;
 reg_fail  NUMBER;
 role_num  NUMBER;
 proxy_db  NUMBER := 0;
 prim_db   NUMBER;
BEGIN
  gsmadmin_internal.dbms_gsm_dbadmin.addService(serv_name, netw_name, rlb_goal,
  clb_goal, dist_trx, aq_notif, aq_ha, lag_prop, max_lagv, fail_meth, fail_type,
  fail_retr, faildelay, ed_name, pdb, commit_oc, retent_to, replay_it, ses_state,
  sql_trans, locality, reg_fail, role_num, proxy_db, prim_db);
END;
/
addService
process_service_attributes

PL/SQL procedure successfully completed.

col network_name format a20
SELECT name, network_name, creation_date
FROM dba_services
ORDER BY 3;

NAME              NETWORK_NAME  CREATION_DATE
----------------- ------------- --------------------
SYS$BACKGROUND                  08-MAR-2017 15:58:08
SYS$USERS                       08-MAR-2017 15:58:08
orabase2          orabase2      21-JUN-2017 21:02:11
orabase2XDB       orabase2XDB   21-JUN-2017 21:02:11
MLIBSERV          MLIBNET       27-DEC-2017 08:12:59
 
ADJUST_LOBOUNDS (new 23ai)
 Adjust low bound values of partition_set in THE gsmadmin_internal.partition_set table during split partitionset operation dbms_gsm_dbadmin.adjust_lobounds(
pset1 IN VARCHAR2,
pset2 IN VARCHAR2);
TBD
 
ADJUST_LOBOUNDS_TMPPSET (new 23ai)
Adjusts the low bound values of a partition_set row in tmp_pset  table in split partitionset operation dbms_gsm_dbadmin.adjust_lobounds_tmppset(
pset    IN VARCHAR2,
psetkey IN VARCHAR2,
blobnd  IN VARCHAR2,
owner   IN VARCHAR2);
TBD
 
ALTAB_ADDPSET (new 23ai)
Execute alter table add partition_set dbms_gsm_dbadmin.altab_addpset(
old_pset_name        IN VARCHAR2,
pset_name            IN VARCHAR2,
tset_name            IN VARCHAR2,
db_name              IN VARCHAR2,
owner                IN VARCHAR2,
target_shardspace_id IN NUMBER,
cat                  IN NUMBER);
TBD
 
ALTAB_ADDPSET_REMOTE (new 23ai)
Executes an alter table add partition_set on remote_db dbms_gsm_dbadmin.altab_addpset_remote(
old_pset_name IN VARCHAR2,
pset_name     IN VARCHAR2,
tset_name     IN VARCHAR2,
db_name       IN VARCHAR2,
owner         IN VARCHAR2);
TBD
 
ALTAB_LOCAL_ADDPSET (new 23ai)
Execute an alter table add partition_set locally dbms_gsm_dbadmin.altab_local_addpset(
owner                IN VARCHAR2,
target_shardspace_id IN NUMBER,
pset_name            IN VARCHAR2,
old_pset_name        IN VARCHAR2,
tset_name            IN VARCHAR2);
TBD
 
ALTAB_UPDPSET (new 23ai)
Executes an update partition set dbms_gsm_dbadmin.altab_updpset(
old_pset_name IN VARCHAR2,
inkeys        IN VARCHAR2,
bhibndstr     IN VARCHAR2);
TBD
 
ALTAB_UPDSHTS (new 23ai)
Execute an update shard_ts move_flag dbms_gsm_dbadmin.altab_updshts(
pset_name    IN VARCHAR2,
in_tset_name IN VARCHAR2,
chunk_num    IN NUMBER,
ssid         IN NUMBER,
is_source    IN BOOLEAN,
reset        IN BOOLEAN);
TBD
 
ALTERALLREFFRAGMENTSUNITTEST
Unit test for various alter table ... partition ... statements dbms_gsm_dbadmin.afterAllRefFragmentsUnitTest(
a_owner IN VARCHAR2,
a_name  IN VARCHAR2);
TBD
 
ATPPUT (new 23ai)
Undocumented dbms_gsm_dbadmin.ATPPut(
atp_key IN  RAW,
err     OUT BINARY_INTEGER);
TBD
 
ATPVALIDATE (new 23ai)
Undocumented dbms_gsm_dbadmin.atpValidate(
enc_sdb_name IN  RAW,
err          OUT BINARY_INTEGER);
TBD
 
CHECKDDLSTATUS (new 23ai)
Undocumented dbms_gsm_dbadmin.checkDDLStatus(
ddl_id IN NUMBER,
status IN NUMBER,
local  IN NUMBER,
ru_id  IN NUMBER DEFAULT 0)
RETURN NUMBER;
TBD
 
CHECKSNRBARRIER (new 23ai)
Undocumented dbms_gsm_dbadmin.CheckSNRBarrier(
is_barrier      OUT NUMBER,
barrier_version OUT NUMBER,
obj_name        OUT VARCHAR2,
ddlid           IN  NUMBER,
schema_name     IN  VARCHAR2,
dbnum           OUT NUMBER);
TBD
 
CHUNKSTATEEXISTS (new 23ai)
CheckS if chunk with chunk_number has given move_flag value in shard_ts table dbms_gsm_dbadmin.chunkStateExists(
chunk_num  IN NUMBER,
move_state IN NUMBER)
RETURN NUMBER;
TBD
 
CLEANTARGET (new 23ai)
Clean local shard of split partitionset operation of any intermediate tablespaces/files created dbms_gsm_dbadmin.cleanTarget;
exec gsmadmin_internal.dbms_gsm_dbadmin.cleanTarget;

PL/SQL procedure successfully completed.
 
CLEANTARGETREMOTE (new 23ai)
Clean target shard of split partitionset operation of any intermediate tablespaces/files created dbms_gsm_dbadmin.cleanTargetRemote(db_name IN VARCHAR2);
TBD
 
CONFIGOGGREPLICATION
Configures Oracle GoldenGate replications dbms_gsm_dbadmin.configOGGReplication;
exec gsmadmin_internal.dbms_gsm_dbadmin.configOGGReplication;
     *
ORA-45568: database link to catalog is invalid

10046 trace was run during the test shown here and revealed the following (reformatted for clarity)

ALTER SESSION SET GLOBAL_NAMES=FALSE
Queries of access$, aud_object_opt$, codeauth$, dependency$, idl_char$, idl_sb4$, idl_ub1$, idl_ub2$, obj$, codeauth$, type$, and view$
A query of v_$Pparameter2 WHERE NAME='_cloud_name'
 
CONTROLCHUNK
According to Oracle "For testing purposes. Not public." dbms_gsm_dbadmin.controlChunk(
chunkid IN BINARY_INTEGER,
op      IN BINARY_INTEGER,
p1      IN BINARY_INTEGER);
TBD
 
CONTROLREMOTECHUNK (new 23ai)
Invokes dbms_gsm_dbadmin controlChunk remotely dbms_gsm_dbadmin.controlRemoteChunk(
chunk_number IN NUMBER,
chunk_id     IN NUMBER,
op           IN NUMBER,
p1           IN NUMBER);
TBD
 
CREATEAPPLYSTARTRU (new 23ai)
Undocumented dbms_gsm_dbadmin.createApplyStartRU(
ru_id               IN BINARY_INTEGER,
copy_par-from_ru_id IN BINARY_INTEGER DEFAULT NULL);
TBD
 
CREATENEWRU (new 23ai)
Undocumented dbms_gsm_dbadmin.createNewRU(
ru_id     IN BINARY_INTEGER,
par_ru    IN BINARY_INTEGER,
gdsctl_id IN NUMBER          DEFAULT 0);
TBD
 
CREATERATABLEFAMILY
Enable RAC affinity for sharded table dbms_gsm_dbadmin.createRATableFamily(
shard_owner IN VARCHAR2,
shard_table IN VARCHAR2);
TBD
 
CREATESHARDDBLINK (new 23ai)
Undocumented dbms_gsm_dbadmin.createShardDBLink(
db_num      IN NUMBER,
link_prefix IN VARCHAR2);
TBD
 
CREATE_APPLY (new 23ai)
Undocumented dbms_gsm_dbadmin.create_apply(
apply_name IN VARCHAR2,
ru_id      IN NUMBER   DEFAULT 1,
apply_user IN VARCHAR2 DEFAULT NULL);
TBD
 
DO_DDL_JOB_WRAPPER (new 23ai)
Undocumented dbms_gsm_dbadmin.do_ddl_job_wrapper(
fromId      IN NUMBER,
toId        IN NUMBER,
chunk_id    IN NUMBER,
operation   IN VARCHAR2,
obj_type    IN VARCHAR2,
doExec      IN BOOLEAN,
ignor_error IN BOOLEAN,
guid        IN VARCHAR2,
seq         IN NUMBER);
TBD
 
DROPRATABLEFAMILY
Disable RAC affinity dbms_gsm_dbadmin.dropRATableFamily;
exec gsmadmin_internal.dbms_gsm_dbadmin.dropRATableFamily;
 
DROP_APPLY (new 23ai)
Undocumented dbms_gsm_dbadmin.drop_apply(apply_name IN VARCHAR2);
TBD
 
ENSUREDBLINK
  dbms_gsm_dbadmin.ensureDBLink(
db_name   IN VARCHAR2,
conn_str  IN VARCHAR2,
gsmusrpwd IN VARCHAR2 DEFAULT NULL);
TBD
 
ENSURE_REMOTE_CONN (new 23ai)
Invokes gws_ensure_remote_conn C function on target shard dbms_gsm_dbadmin.ensure_remote_conn(
chunk_num IN BINARY_INTEGER,
sssid     IN BINARY_INTEGER);
TBD
 
EXECUTEDDLCALLBACK
Executex a DDL statement callback dbms_gsm_dbadmin.executeDDLCallBack;
exec gsmadmin_internal.dbms_gsm_dbadmin.executeDDLCallBack;
 
EXECUTEDDLPRVT
Execute DDL statement dbms_gsm_dbadmin.executeDDLPrvt(
ddlid          IN OUT NUMBER,
schema_name    IN     VARCHAR2,
ddl_text       IN     CLOB     DEFAULT NULL,
operation_type IN     CHAR,
params         IN     VARCHAR2 DEFAULT NULL,
ddlaction      IN     NUMBER   DEFAULT dbms_gsm_common.execddl_default,
runddl            OUT BOOLEAN);
DECLARE
 idVal  NUMBER := 42;
 ddlAct NUMBER := gsmadmin_internal.dbms_gsm_common.execddl_default;
 tfVal  BOOLEAN;
BEGIN
  gsmadmin_internal.dbms_gsm_dbadmin.executeDDLPrvt(idVal, 'SYS\', 'CREATE USER c##zzyzx', 'C', NULL, ddlAct, tfVal);
  IF tfVal THEN
    dbms_output.put_line('T');
  ELSE
    dbms_output.put_line('F');
  END IF;
END;
/
F

PL/SQL procedure successfully completed.

SELECT username FROM dba_users WHERE username LIKE 'C%' ORDER BY 1;

USERNAME
-------------------------
C##ABC
C##OOUG
C##SEC_ADMIN
C##ZZYZX
CTXSYS

-- I tried to grant DBA to the new user and was unable to but that may be the result
-- of using the wrong OPERATION_TYPE parameter rather than this proc being unable to
-- be a major security exploit. Until proven otherwise we recommend grants of execute
-- not be made without first opening an SR.
 
EXECUTEGENERICPROCEDURE
Undocumented dbms_gsm_dbadmin.executeGenericProcedure(
payload       IN  VARCHAR2,
change_type   IN  NUMBER,
response_code OUT NUMBER,
response_info OUT VARCHAR2);
TBD
 
EXPORTMETADATA
Undocumented dbms_gsm_dbadmin.exportMetadata(chunk_id IN NUMBER);
TBD
 
FETCHEXECDDLSFROMCATALOG (new 23ai)
For shards added with clone option, wait for DDLs to be extracted on the catalog, fetch them and then execute them dbms_gsm_dbadmin.fetchExecDDLsFromCatalog(
ddlaction IN NUMBER DEFAULT dbms_gsm_common.execddl_default);
TBD
 
FINISHMOVE
Undocumented dbms_gsm_dbadmin.finishMove(
chunk_id IN BINARY_INTEGER,
db_role  IN BINARY_INTEGER DEFAULT dbms_gsm_common.movechunk_source,
status   IN BINARY_INTEGER DEFAULT dbms_gsm_common.movechunk_success,
timeout  IN BINARY_INTEGER DEFAULT 0);
TBD
 
GENERATE_TABLESPACE_NAME (new 23ai)
Generates new tablespace name from given tablespace and chunk_id during split chunk.

Internal procedure, not for public use.		 dbms_gsm_dbadmin.generate_tablespace_name(
ts_name    IN  VARCHAR2,
chunk_id   IN  BINARY_INTEGER,
newts_name OUT VARCHAR2);
TBD
 
GETBHIBNDVAL (new 23ai)
Get value for HIBOUNDVAL field in partition_set table dbms_gsm_dbadmin.getBHiBndVal(pset_name IN VARCHAR2) RETURN VARCHAR2;
TBD
 
GETCATDDLSTATUSCNT (new 23ai)
Undocumented dbms_gsm_dbadmin.getCatDDLStatusCnt RETURN NUMBER;
SELECT gsmadmin_internal.getCatDDLStatusCnt;
       *
ORA-02019: connection description for remote database not found
 
GETCONNSTRBYCONTAINER (new 23ai)
Returns a container connection string dbms_gsm_dbadmin.getConnStrByContainer(name IN VARCHAR2) RETURN VARCHAR2;
SELECT gsmadmin_internal.getConnStrByContainer('FREEPDB1');
       *
ORA-02019: connection description for remote database not found
 
GETCRSINFO
Returns CRS information dbms_gsm_dbadmin.getCRSInfo(
ons_port   OUT VARCHAR2,
scan_name  OUT VARCHAR2,
rac_status OUT PLS_INTEGER);
DECLARE
 ons_out  VARCHAR2(30);
 scan_out VARCHAR2(30);
 rac_stat PLS_INTEGER;
BEGIN
  gsmadmin_internal.dbms_gsm_dbadmin.getCRSInfo(ons_out, scan_out, rac_stat);
  dbms_output.put_line('ONS:  ' || ons_out);
  dbms_output.put_line('SCAN: ' || scan_out);
  dbms_output.put_line('RAC:  ' || TO_CHAR(rac_stat));
END;
/
ONS:
SCAN:
RAC:  0
 
GETCURCATDDLID (new 23ai)
Undocumented dbms_gsm_dbadmin.getCurCatDDLId(barrier IN NUMBER DEFAULT 0) RETURN NUMBER;
SELECT gsmadmin_internal.dbms_gsm_dbadmin.getCurCatDDLId(0);
       *
ORA-02019: connection description for remote database not found
 
GETDATATABLESPACE (new 23ai)
Returns the default data tablespace name for given partition dbms_gsm_dbadmin.getDataTableSpace(
owner IN VARCHAR2,
tname IN VARCHAR2,
pname IN VARCHAR2)
RETURN VARCHAR2;
TBD
 
GETDBBYCHUNKSSID (new 23ai)
Returns the database details from chunk number and ssid dbms_gsm_dbadmin.getDbByChunkSSid(
chunk_num IN NUMBER,
ssid      IN NUMBER)
RETURN VARCHAR2;
TBD
 
GETDBLINKNAME (new 23ai)
Undocumented dbms_gsm_dbadmin.getDbLinkName(db_name IN VARCHAR2) RETURN VARCHAR2;
TBD
 
GETDBNUMBERRANGE
Undocumented dbms_gsm_dbadmin.getDBNUMBERRange(
cur_NUMBER IN     NUMBER,
range_min  IN OUT NUMBER,
range_max  IN OUT NUMBER);
DECLARE
 cnum NUMBER := 1;
 rmin NUMBER := 1;
 rmax NUMBER := 6;
BEGIN
  gsmadmin_internal.dbms_gsm_dbadmin.getDBNUMBERRange(cnum, rmin, rmax);
  dbms_output.put_line(TO_CHAR(cnum));
  dbms_output.put_line(TO_CHAR(rmin));
  dbms_output.put_line(TO_CHAR(rmax));
END;
/
 
GETENCPWD (new 23ai)
Returns the encrypted password from a connect_string dbms_gsm_dbadmin.getEncPwd(
conn_str IN  VARCHAR2,
enc_pwd  OUT VARCHAR2,
enc_len  OUT NUMBER);
DECLARE
 ep dbms_id;
 el NUMBER;
BEGIN
  gsmadmin_internal.dbms_gsm_dbadmin.getEncPwd('SCOTTTIGER', ep, el);
END;
/

PL/SQL procedure successfully completed.

 -- nothing was returned.
 
GETFAMILYTABNAMES (new 23ai)
Returns the Table Names in the Table Family from the Root Table name dbms_gsm_dbadmin.getFamilyTabNames(root_name IN VARCHAR2) RETURN family_tname_t;
TBD
 
GETGSMINFO
Returns information about the database for GSM dbms_gsm_dbadmin.getGSMInfo RETURN gsmadmin_internal.gsmInfo;
DECLARE
 retVal gsmadmin_internal.gsm_Info;
BEGIN
  retVal := gsmadmin_internal.dbms_gsm_dbadmin.getGSMInfo;
  dbms_output.put_line('Cloud:      ' || retVal.cloud_name);
  dbms_output.put_line('DB Pool     ' || retVal.dbpool_name);
  dbms_output.put_line('Region      ' || retVal.region_name);
  dbms_output.put_line('DB NUMBER:  ' || TO_CHAR(retVal.database_num));
  dbms_output.put_line('Scan Name   ' || retVal.scan_name);
  dbms_output.put_line('DB NUMBER:  ' || TO_CHAR(retVal.dbrole));
  dbms_output.put_line('CPU Thresh: ' || TO_CHAR(retVal.cpu_threshold));
  dbms_output.put_line('DB NUMBER:  ' || TO_CHAR(retVal.reptype));
  dbms_output.put_line('Filv Conv:  ' || retVal.file_convert);
  dbms_output.put_line('File Dest:  ' || retVal.file_dest);
END;
/

-- this demo does not output all values returned by getGSMInfo
 
GETHIBNDVAL (new 23ai)
Returns the value for HIBOUNDVAL field in partition_set table dbms_gsm_dbadmin.getHiBndVal(pset_name IN VARCHAR2) RETURN VARCHAR2;
TBD
 
GETHOSTINFO
Returns information about connected host for GSM

Overload 1		 dbms_gsm_dbadmin.getHostInfo(
ons_port  OUT VARCHAR2,
scan_name OUT VARCHAR2,
hostname  OUT VARCHAR2);
DECLARE
 ons_out VARCHAR2(60);
 scan_out VARCHAR2(60);
 host_out VARCHAR2(60);
BEGIN
  gsmadmin_internal.dbms_gsm_dbadmin.getHostInfo(ons_out, scan_out, host_out);
  dbms_output.put_line('ONS: '  || ons_out);
  dbms_output.put_line('Scan: ' || scan_out);
  dbms_output.put_line('Host: ' || host_out);
END;
/
ONS:
Scan:
Host: PERRITO5

PL/SQL procedure successfully completed.
Overload 2 dbms_gsm_dbadmin.getHostInfo(
ons_port  OUT VARCHAR2,
scan_name OUT VARCHAR2,
hostname  OUT VARCHAR2,
db_type   OUT CHAR);
DECLARE
 ons_out VARCHAR2(60);
 scan_out VARCHAR2(60);
 host_out VARCHAR2(60);
 dbt_out VARCHAR2(60);
BEGIN
  gsmadmin_internal.dbms_gsm_dbadmin.getHostInfo(ons_out, scan_out, host_out);
  dbms_output.put_line('ONS: '     || ons_out);
  dbms_output.put_line('Scan: '    || scan_out);
  dbms_output.put_line('Host: '    || host_out);
  dbms_output.put_line('DB Type: ' || dbt_out);
END;
/
ONS:
Scan:
Host: PERRITO5
DB Type:

PL/SQL procedure successfully completed.
 
GETKNCLPCAPCURVSN (new 23ai)
Returns the KNCLP_CAP_CUR_VSN C macro dbms_gsm_dbadmin.getKnclpCapCurVsn RETURN BINARY_INTEGER;
SELECT gsmadmin_internal.dbms_gsm_dbadmin.getKnclpCapCurVsn

GETKNCLPCAPCURVSN
-----------------
               12
 
GETLATESTDDLID (new 23ai)
Returns the most recnet ddiid from gsmadmin_internal.catalog dbms_gsm_dbadmin.getLatestDDLId RETURN NUMBER;
SELECT gsmadmin_internal.dbms_gsm_dbadmin.getLatestDDLId;
       *
ORA-02019: connection description for remote database not found
 
GETLOBTABLESPACE (new 23ai)
Returns tablespaces names used for LOBs in the named partition dbms_gsm_dbadmin.getLobTableSpace(
owner IN VARCHAR2,
tname IN VARCHAR2,
pname IN VARCHAR2)
RETURN lob_ts_t;
TBD
 
GETLOBTSCOUNT (new 23ai)
Returns the tablespace count used for lobs in the named partition dbms_gsm_dbadmin.getLobTSCount(
owner IN VARCHAR2,
tname IN VARCHAR2,
pname IN VARCHAR2)
RETURN NUMBER;
TBD
 
GETLOCALCHUNKNUMBERS (new 23ai)
Returns Local Chunk Numbers dbms_gsm_dbadmin.getLocalChunkNumbers RETURN chunk_num_t;
TBD
 
GETLOCALPENDINGCHUNKNUMBERS (new 23ai)
Returns Local Chunk Numbers Pending Partitionset Split dbms_gsm_dbadmin.getLocalPendingChunkNumbers(
db_name  IN VARCHAR2,
tbs_name IN VARCHAR2)
RETURN chunk_num_t;
TBD
 
GETLOCALSHARDSPACEID (new 23ai)
Returns Table Names in Table Family from Root Table name dbms_gsm_dbadmin.getLocalShardSpaceId RETURN NUMBER;
SELECT gsmadmin_internal.dbms_gsm_dbadmin.getLocalShardSpaceId;

GETLOCALSHARDSPACEID
--------------------
 
 
GETMAXSTARTCATDDLID (new 23ai)
Undocumented dbms_gsm_dbadmin.getMaxStartCatDDLid RETURN NUMBER;
SELECT gsmadmin_internal.dbms_gsm_dbadmin.getMaxStartCatDDLid;

GETMAXSTARTCATDDLID
-------------------
                  0
 
GETOBJECTID (new 23ai)
Returns the object id of table from name and owner dbms_gsm_dbadmin.getObjectID(
t_name  IN VARCHAR2,
t_owner IN VARCHAR2,
d_obj   IN NUMBER)
RETURN NUMBER;
TBD
 
GETREMOTECONNSTR (new 23ai)
Returns the connect string for remote database on different shardspace for a given chunk_number dbms_gsm_dbadmin.getRemoteConnStr(
chunk_number        IN NUMBER,
local_shardspace_id IN NUMBER)
RETURN connstr_t;
TBD
 
GETREMOTEENCSECRET (new 23ai)
Returns the GSM encrypted password of target shard. To be executed from one of the shards and not the catalog dbms_gsm_dbadmin.getRemoteEncSecret(
target_dbname IN  VARCHAR2,
secret        OUT RAW,
seclen        OUT NUMBER,
use_conn      IN  BINARY_INTEGER DEFAULT 0);
DECLARE
 r RAW(32767);
 n NUMBER;
BEGIN
  gsmadmin_internal.dbms_gsm_dbadmin.getRemoteEncSecret('FREEPDB1', r, n, 0);
  dbms_output.put_line(r);
  dbms_output.put_line(n);
END;
/
*
PLS-00352: Unable to access another database 'GDS$CATALOG.LINK'
 
GETREMOTEROWCOUNT (new 23ai)
Returns the row count of remote table with given sys_hashval range dbms_gsm_dbadmin.getRemoteRowCount(
schema    IN VARCHAR2,
tname     IN VARCHAR2,
loval     IN VARCHAR2,
hival     IN VARCHAR2,
chunk_num IN NUMBER)
RETURN NUMBER;
TBD
 
GETREPLTYPE (new 23ai)
Undocumented dbms_gsm_dbadmin.getReplType RETURN NUMBER;
SELECT gsmadmin_internal.dbms_gsm_dbadmin.getReplType;

GETREPLTYPE
-----------
          0
 
GETSHARDINGMETHOD (new 23ai)
Returns the sharding method number dbms_gsm_dbadmin.getShardingMethod RETURN BINARY_INTEGER
ACCESSIBLE BY (PACKAGE sys.dbms_gsm_fixed);
TBD
 
GETSHARDSPACEBYTS (new 23ai)
Returns the Shardspace Name from the Tablespace (which shardspace the tablespace resides) dbms_gsm_dbadmin.getShardspaceByTS(ts_name IN VARCHAR2) RETURN VARCHAR2;
SELECT gsmadmin_internal.dbms_gsm_dbadmin.getShardspaceByTS('USERS');
       *
ORA-02019: connection description for remote database not found
 
GETSHARDSPACEIDBYPSET (new 23ai)
Returns the Shardspace Id from the  Partitionset Name (which shardspace the partitionset resides) dbms_gsm_dbadmin.getShardspaceIdByPSet(pset_name IN VARCHAR2) RETURN NUMBER;
TBD
 
GETSHARDSPACEIDBYTS (new 23ai)
Returns the Shardspace Id from Tablespace (which shardspace the tablespace resides) dbms_gsm_dbadmin.getShardspaceIdByTS(ts_name IN VARCHAR2) RETURN NUMBER;
TBD
 
GETSSCHUNKNUMBERS (new 23ai)
Returns Shard Space Chunk Numbers dbms_gsm_dbadmin.getSSChunkNumbers(ssid IN NUMBER) RETURN chunk_num_t;
TBD
 
GETTARGETDBCONNSTR (new 23ai)
Returns the Target Db Connect String from Chunk Id and Target Tablespace dbms_gsm_dbadmin.getTargetDbConnStr(
ts_name   IN VARCHAR2,
chunk_num IN NUMBER)
RETURN VARCHAR2;
TBD
 
GETTARGETDBNAME (new 23ai)
Returns the Target Db Name from Chunk Id and Target Tablespace dbms_gsm_dbadmin.getTargetDbName(
ts_name   IN VARCHAR2,
chunk_num IN NUMBER)
RETURN VARCHAR2;
TBD
 
GETTARGETDBSBYSSID (new 23ai)
Return a list of target database numbers for a shardspace id dbms_gsm_dbadmin.getTargetDBsBySSID(ssid IN NUMBER) RETURN dbnum_t;
TBD
 
GETTSSETBYTBLSPACE (new 23ai)
Returns the name of tablespace set for given tablespace dbms_gsm_dbadmin.getTSSetbyTblSpace(tspc_name IN VARCHAR2) RETURN VARCHAR2;
TBD
 
GET_CLONE_STATUS (new 23ai)
Returns the cloning operation status of a newly added shard dbms_gsm_dbadmin.get_clone_status RETURN NUMBER;
SELECT gsmadmin_internal.dbms_gsm_dbadmin.get_clone_status;

GET_CLONE_STATUS
----------------
               1
 
GRABCHUNKSFROMCATALOG
Gets chunks from the catalog database dbms_gsm_dbadmin.grabChunksFromCatalog;
exec gsmadmin_internal.dbms_gsm_dbadmin.grabChunksFromCatalog;
     *
ORA-45568: database link to catalog is invalid
 
IMPORTDATA
Undocumented dbms_gsm_dbadmin.importData(md_fname IN VARCHAR2);
TBD
 
IMPORTDATA2
Undocumented dbms_gsm_dbadmin.importData2(chunk_id IN NUMBER);
TBD
 
INITIATEDDLSTATUS (new 23ai)
Undocumented dbms_gsm_dbadmin.initiateDDLStatus(
ddl_id     IN  NUMBER,
ru_id      IN  NUMBER,
status     IN  NUMBER,
cat_ddl_id OUT NUMBER);
TBD
 
INSSPSMON (new 23ai)
Undocumented dbms_gsm_dbadmin.insSPSMon(
ddlid     IN NUMBER,
owner     IN VARCHAR2,
tname     IN VARCHAR2,
chunk_num IN NUMBER);
TBD
 
INSSTARTCHUNKSPLITPSETSTAT (new 23ai)
Insert a row for chunk operation start in v$split_pset_stat table dbms_gsm_dbadmin.insStartChunkSplitPsetStat(
ddlid     IN NUMBER,
owner     IN VARCHAR2,
rt_name   IN VARCHAR2,
chunk_num IN NUMBER);
TBD
 
INSTSCHUNKSPLITPSETSTAT (new 23ai)
Insert a row for chunk operation export tablespace in v$split_pset_stat table dbms_gsm_dbadmin.insTSChunkSplitPsetStat(
ddlid     IN NUMBER,
owner     IN VARCHAR2,
rt_name   IN VARCHAR2,
ts_name   IN VARCHAR2,
chunk_num IN NUMBER);
TBD
 
ISCATBARDDL (new 23ai)
Undocumented dbms_gsm_dbadmin.isCatBarDDL(ddl_id IN NUMBER) RETURN NUMBER;
TBD
 
ISCATDDLCOMPLETE (new 23ai)
Undocumented dbms_gsm_dbadmin.isCatDDLComplete(ddl_id IN NUMBER) RETURN NUMBER;
TBD
 
ISINDDLCATCHUP (new 23ai)
Undocumented dbms_gsm_dbadmin.isInDDLCatchup(db_num IN NUMBER) RETURN BOOLEAN;
TBD
 
LEAVERU (new 23ai)
Undocumented dbms_gsm_dbadmin.leaveRU(ru_id IN BINARY_INTEGER,
doClean    IN NUMBER DEFAULT dbms_gsm_common.isFalse,
doCommit   IN NUMBER DEFAULT dbms_gsm_common.isFalse,
doMDRemove IN NUMBER DEFAULT dbms_gsm_common.isTrue);
TBD
 
LOAD_CAT_QP_DATA (new 23ai)
Undocumented dbms_gsm_dbadmin.load_cat_qp_data;
SELECT gsmadmin_internal.dbms_gsm_dbadmin.load_cat_qp_data;
       *
PLS-00352: Unable to access another database 'GDS$CATALOG.LINK'
 
MODIFYDATABASE
Changes the database's region dbms_gsm_dbadmin.modifyDatabase(
region_name  IN VARCHAR2,
cpu_thresh   IN NUMBER DEFAULT NULL,
srlat_thresh IN NUMBER DEFAULT NULL);
TBD
 
MODIFYGSM
Informs the database of GSM attribute changes dbms_gsm_dbadmin.modifyGSM(
gsm_alias   IN VARCHAR2,
endpoint    IN VARCHAR2 DEFAULT NULL,
region_name IN VARCHAR2 DEFAULT NULL,
ons_port    IN NUMBER   DEFAULT NULL);
TBD
 
MODIFYREGION
Inform the database of region attribute modifications dbms_gsm_dbadmin.modifyRegion(
region_name  IN VARCHAR2,
buddy_region IN VARCHAR2 DEFAULT NULL);
TBD
 
MODIFYSERVICE
Modifies all attributes of a global service dbms_gsm_dbadmin.modifyService(
service_name              IN  VARCHAR2,
rlb_goal                  IN  NUMBER   DEFAULT NULL,
clb_goal                  IN  NUMBER   DEFAULT NULL,
distr_trans               IN  NUMBER   DEFAULT NULL,
aq_notifications          IN  NUMBER   DEFAULT NULL,
aq_ha_notifications       IN  NUMBER   DEFAULT NULL,
lag_property              IN  NUMBER   DEFAULT NULL,
max_lag_value             IN  NUMBER   DEFAULT NULL,
failover_method           IN  VARCHAR2 DEFAULT NULL,
failover_type             IN  VARCHAR2 DEFAULT NULL,
failover_retries          IN  NUMBER   DEFAULT NULL,
failover_delay            IN  NUMBER   DEFAULT NULL,
edition                   IN  VARCHAR2 DEFAULT NULL,
pdb                       IN  VARCHAR2 DEFAULT NULL,
commit_outcome            IN  NUMBER   DEFAULT NULL,
retention_timeout         IN  NUMBER   DEFAULT NULL,
replay_initiation_timeout IN  NUMBER   DEFAULT NULL,
session_state_consistency IN  VARCHAR2 DEFAULT NULL,
sql_translation_profile   IN  VARCHAR2 DEFAULT NULL,
locality                  IN  NUMBER   DEFAULT NULL,
region_failover           IN  NUMBER   DEFAULT NULL,
role                      IN  NUMBER   DEFAULT NULL,
network_number            IN  NUMBER   DEFAULT NULL,
server_pool               IN  VARCHAR2 DEFAULT NULL,
cardinality               IN  VARCHAR2 DEFAULT NULL,
proxy_db                  IN  NUMBER   DEFAULT 0,
primary_db                OUT NUMBER,
instances                 IN  VARCHAR2 DEFAULT NULL,
force                     IN  NUMBER   DEFAULT dbms_gsm_common.isFalse);
DECLARE
 primDB VARCHAR2(30);
BEGIN
  gsmadmin_internal.dbms_gsm_dbadmin.getHost('MLIBSVC',
  clb_goal => dbms_service.clb_goal_short, primDB);
  dbms_output.put_line(primDB);
END;
/
 
MODIFYSERVICEGLOBALPARAMETERS
Modifies all global attributes of a global service

Overload 1		 dbms_gsm_dbadmin.modifyServiceGlobalParameters(
service_name              IN  VARCHAR2,
rlb_goal                  IN  NUMBER,
clb_goal                  IN  NUMBER,
distr_trans               IN  NUMBER,
aq_notifications          IN  NUMBER,
aq_ha_notifications       IN  NUMBER,
lag_property              IN  NUMBER,
max_lag_value             IN  NUMBER,
failover_method           IN  VARCHAR2,
failover_type             IN  VARCHAR2,
failover_retries          IN  NUMBER,
failover_delay            IN  NUMBER,
edition                   IN  VARCHAR2,
pdb                       IN  VARCHAR2,
commit_outcome            IN  NUMBER,
retention_timeout         IN  NUMBER,
replay_initiation_timeout IN  NUMBER,
session_state_consistency IN  VARCHAR2,
sql_translation_profile   IN  VARCHAR2,
locality                  IN  NUMBER,
region_failover           IN  NUMBER,
role                      IN  NUMBER,
proxy_db                  IN  NUMBER,
primary_db                OUT NUMBER,
force                     IN  NUMBER DEFAULT dbms_gsm_common.isFalse);
TBD
Overload 2 dbms_gsm_dbadmin.modifyServiceGlobalParameters(
p_service  IN  service_dsc_t,
primary_db OUT NUMBER,
force      IN  NUMBER DEFAULT dbms_gsm_common.isFalse);
TBD
 
MODIFYSERVICELOCALPARAMETERS
Modifies all local attributes of a global service dbms_gsm_dbadmin.modifyServiceLocalParameters(
service_name   IN VARCHAR2,
network_number IN NUMBER,
server_pool    IN VARCHAR2,
cardinality    IN VARCHAR2,
instances      IN VARCHAR2 DEFAULT NULL,
force          IN NUMBER   DEFAULT dbms_gsm_common.isFalse);
TBD
 
MOVECHUNK
Move Chunk information dbms_gsm_dbadmin.moveChunk(
chunk_id  IN BINARY_INTEGER,
conn_str  IN VARCHAR2,
timeout   IN BINARY_INTEGER,
move_mode IN BINARY_INTEGER,
gsmusrpwd IN VARCHAR2,
gdsctl_id IN BINARY_INTEGER DEFAULT 0);
TBD
 
MOVELOGFILES (new 23ai)
Undocumented dbms_gsm_dbadmin.moveLogFiles(ru_id IN BINARY_INTEGER);
TBD
 
MOVERU (new 23ai)
Undocumented dbms_gsm_dbadmin.moveru(
ru_id      IN BINARY_INTEGER,
db_num     IN BINARY_INTEGER,
timeout    IN BINARY_INTEGER DEFAULT 0,
move_mode  IN BINARY_INTEGER DEFAULT 0,
gdsctl_id  IN NUMBER         DEFAULT 0,
repl_dbnum IN BINARY_INTEGER DEFAULT 0);
TBD
 
PDBADD_SERVICE (new 23ai)
Undocumented dbms_gsm_dbadmin.pdbadd_service(
service_name IN VARCHAR2,
network_name IN VARCHAR2,
cl_params    IN svc_params,
cl_values    IN svc_params,
db_params    IN svc_params,
db_values    IN svc_params,
srvc_ctx     IN NUMBER);
TBD
 
PDBMODIFY_SERVICE (new 23ai)
Undocumented dbms_gsm_dbadmin.pdbmodify_service(
service_name IN VARCHAR2,
cl_params    IN svc_params,
cl_values    IN svc_params,
db_params    IN svc_params,
db_values    IN svc_params,
srvc_ctx     IN NUMBER);
TBD
 
PREPAREMETADATALOCAL
Undocumented dbms_gsm_dbadmin.prepareMetadataLocal(chunk_id IN NUMBER);
TBD
 
PREPAREMETADATAREMOTE
Undocumented dbms_gsm_dbadmin.prepareMetadataRemote(
chunk_id   IN NUMBER,
tab_filter IN VARCHAR2 DEFAULT NULL);
TBD
 
PROPAGATERUROLE (new 23ai)
Undocumented dbms_gsm_dbadmin.propagateRURole(
ru_id IN BINARY_INTEGER,
term  IN NUMBER,
role  IN BINARY_INTEGER);
TBD
 
PSEXISTS (new 23ai)
Checks if partition set with given name exists dbms_gsm_dbadmin.psExists(ps_name IN VARCHAR2) RETURN NUMBER;
TBD
 
PTSHDBUILDALLOWEDSCHEMAS (new 23ai)
Creates a list of schemas that we consider ok to depend on dbms_gsm_dbadmin.PROCEDURE ptshdBuildAllowedSchemas(
result_list          IN OUT NOCOPY schema_list_t,
schemas              IN            schema_list_t DEFAULT NULL,
includeOracleSchemas IN            BOOLEAN       DEFAULT TRUE,
includePublic        IN            BOOLEAN       DEFAULT TRUE);
TBD
 
PTSHDBUILDINCLEXPR (new 23ai)
Builds an IN(...) expression based on list of input names dbms_gsm_dbadmin.ptshdBuildInclExpr(
names           IN schema_list_t,
additional_name IN VARCHAR2 DEFAULT NULL)
RETURN VARCHAR2;
TBD
 
PTSHDFILTEROBJECTS (new 23ai)
For every object in  ptshd_schema_objects, check if  dependent objects are also in ptshd_schema_objects dbms_gsm_dbadmin.ptshdFilterObjects;
exec gsmadmin_internal.dbms_gsm_dbadmin.ptshdFilterObjects;

PL/SQL procedure successfully completed.
 
PTSHDMATCHOBJTYPE (new 23ai)
Match a string object type to operation types defined in dbms_gsm_utility dbms_gsm_dbadmin.ptshdMatchObjType(
object_type    IN     VARCHAR2,
operation_type IN OUT CHAR);
TBD
 
PTSHDVALIDATEDEPENDENCY (new 23ai)
For every object retrieved from DBMS_METADATA API, check if it depends on schemas outside the list of schemas provided dbms_gsm_dbadmin.ptshdValidateDependency(
schema_name         IN            VARCHAR2,
object_name         IN            VARCHAR2,
object_type         IN            VARCHAR2,
allowed_schema_list IN            schema_list_t,
has_dependency      IN OUT NOCOPY CHAR)
RETURN BOOLEAN;
TBD
 
RBLDALLINDEXES (new 23ai)
Rebuild local indexes for all partitions involved in a chunk dbms_gsm_dbadmin.rbldAllIndexes(chunk_number IN NUMBER);
TBD
 
RBLDINDEXES (new 23ai)
Rebuild local indexes for specified table partition except primary key index dbms_gsm_dbadmin.rbldIndexes(
tname  IN VARCHAR2,
schema IN VARCHAR2,
pname  IN VARCHAR2);
TBD
 
RECOVERCHUNKS
Recovers Chunk information after an unsuccessful move or split dbms_gsm_dbadmin.recoverChunks;
exec gsmadmin_internal.dbms_gsm_dbadmin.recoverChunks;
 
RECOVERSHARDDDLCLONE (new 23ai)
Runs recovery of failed DDLs when shard cloning is incomplete for new shard dbms_gsm_dbadmin.recoverShardDDLClone(
ddlid         IN  NUMBER,
ddlaction     IN  NUMBER,
response_code OUT NUMBER,
response_info OUT VARCHAR2);
TBD
 
RELOCATECHUNKSRU (new 23ai)
Undocumented dbms_gsm_dbadmin.relocateChunksRU(
oru        IN BINARY_INTEGER,
nru        IN BINARY_INTEGER,
timeout    IN BINARY_INTEGER,
chunk_list IN chunk_list_t,
gdsctl_id  IN NUMBER DEFAULT 0);
TBD
 
REMOVEALLSERVICES
Stops and deletes all the global services dbms_gsm_dbadmin.removeAllServices;
exec gsmadmin_internal.dbms_gsm_dbadmin.removeAllServices;

PL/SQL procedure successfully completed.
 
REMOVEDATABASE
Remove a database from the GDS framework (cloud) dbms_gsm_dbadmin.removeDatabase(db_only IN BOOLEAN DEFAULT FALSE);
exec gsmadmin_internal.dbms_gsm_dbadmin.removeDatabase(TRUE);
 
REMOVEGSM
Informs the database of GSM removal dbms_gsm_dbadmin.removeGSM(gsm_alias IN VARCHAR2);
exec gsmadmin_internal.dbms_gsm_dbadmin.removeGSM('UWGSM');

PL/SQL procedure successfully completed.
 
REMOVEREGION
Inform the database of a region removal dbms_gsm_dbadmin.removeRegion(region_name IN VARCHAR2);
TBD
 
REMOVERU (new 23ai)
Undocumented dbms_gsm_dbadmin.removeRU(
ru_id     IN BINARY_INTEGER,
timeout   IN NUMBER DEFAULT 0,
gdsctl_id IN NUMBER DEFAULT 0);
TBD
 
REMOVESERVICE
Removes a service from CRS and/or the database dbms_gsm_dbadmin.removeService(
service_name   IN  VARCHAR2,
proxy_db       IN  NUMBER DEFAULT 0,
delete_to_move IN  NUMBER DEFAULT 0,
primary_db     OUT NUMBER);
TBD
 
RENAME_PSET (new 23ai)
Updates the entry for this partitionset in parttiion_set table with a new name dbms_gsm_dbadmin.rename_pset(
old_pset_name IN VARCHAR2,
new_pset_name IN VARCHAR2,
reset_status  IN BINARY_INTEGER);
TBD
 
REPLACERUPEER (new 23ai)
Undocumented dbms_gsm_dbadmin.replaceRUPeer(
ru_id    IN NUMBER,
old_peer IN NUMBER,
new_peer IN NUMBER);
TBD
 
RESTORECHUNK
Restores chunk partitions reassigning their tablespaces and recreating them if needed dbms_gsm_dbadmin.restoreChunk(
a_chunk_id      IN BINARY_INTEGER,
a_shardspace_id IN BINARY_INTEGER,
do_remove       IN BINARY_INTEGER default 0);
TBD
 
SCHEDULENOWRBLDALL (new 23ai)
Schedule a job which runs immediately and rebuilds local indexes for all partitions involved in a chunk dbms_gsm_dbadmin.scheduleNowRbldAll(chunk_number IN NUMBER);
TBD
 
SEND_GDSCTL_MSG
Undocumented dbms_gsm_dbadmin.send_gdsctl_msg(
message      IN VARCHAR2,
gdsctl_sid   IN NUMBER,
message_type IN NUMBER DEFAULT dbms_gsm_utility.msg_message);
TBD
 
SETCATALOGLINK
Creates a database link from shard to catalog dbms_gsm_dbadmin.setCatalogLink(
gsmusrpwd    IN VARCHAR2,
gsm_endpoint IN VARCHAR2,
no_check     IN NUMBER DEFAULT dbms_gsm_common.isFalse);
TBD
 
SETCHUNKS
Initial chunk assignment to database dbms_gsm_dbadmin.setChunks(chunk_list IN chunk_list_t);
TBD
 
SETCHUNKSTATE (new 23ai)
Set state of a chunk with given shardspace_id in chunks table dbms_gsm_dbadmin.setChunkState(
chunk_number IN NUMBER,
ssid         IN NUMBER,
chunk_state  IN NUMBER,
cat          IN NUMBER);
TBD
 
SETDDLTIMEOUT
Set ddl_lock_timeout value to the maximum of (old_value, new_value) dbms_gsm_dbadmin.setDDLTimeOut(new_value IN BINARY_INTEGER);

Return Values:
GWM_NORAC       constant pls_integer := 0; -- database not on RAC
GWM_RAC_ADMIN   constant pls_integer := 1; -- database on admin managed RAC
GWM_RAC_POLICY  constant pls_integer := 2; -- database on policy managed RAC
GWM_RAC_UNKNOWN constant pls_integer := 3; -- unknown RAC status
GWM_RAC_SIHA    constant pls_integer := 4; -- database on SIHA
GWM_RAC_ONE     constant pls_integer := 5; -- database is RAC One Node
exec gsmadmin_internal.dbms_gsm_dbadmin.setDDLTimeOut(0);

PL/SQL procedure successfully completed.
 
SETDFLTLOBTBLSPC (new 23ai)
Set default tablespace for lob column on target shard as part of split partitionset operation dbms_gsm_dbadmin.setDfltLobTblSpcRemote(
db_name     IN VARCHAR2,
owner       IN VARCHAR2,
t_name      IN VARCHAR2,
p_name      IN VARCHAR2,
lobcol_name IN VARCHAR2,
tbs_name    IN VARCHAR2);
TBD
 
SETDFLTLOBTBLSPCREMOTE (new 23ai)
Set default tablespace for lob column on target shard as part of split partitionset operation dbms_gsm_dbadmin.setDfltLobTblSpcRemote(
db_name     IN VARCHAR2,
owner       IN VARCHAR2,
t_name      IN VARCHAR2,
p_name      IN VARCHAR2,
lobcol_name IN VARCHAR2,
tbs_name    IN VARCHAR2);
TBD
 
SETDFLTPTNTBLSPC (new 23ai)
Set default tablespace for partition on local shard as part of split partitionset operation dbms_gsm_dbadmin.setDfltPtnTblSpc(
owner    IN VARCHAR2,
t_name   IN VARCHAR2,
p_name   IN VARCHAR2,
tbs_name IN VARCHAR2);
TBD
 
SETDFLTPTNTBLSPCREMOTE (new 23ai)
Set default tablespace for partition on target shard as part of split partitionset operation dbms_gsm_dbadmin.setDfltPtnTblSpcRemote(
db_name IN VARCHAR2,
owner    IN VARCHAR2,
t_name   IN VARCHAR2,
p_name   IN VARCHAR2,
tbs_name IN VARCHAR2);
TBD
 
SETPARAMETER (new 23ai)
Set SNR RU parameters dbms_gsm_dbadmin.setParameter(
ru_id     IN BINARY_INTEGER,
parameter IN VARCHAR2,
value     IN VARCHAR2 DEFAULT NULL);
TBD
 
SETRATABLEFAMILY
Enable RAC affinity for a table dbms_gsm_dbadmin.setRATableFamily(
table_name   IN     VARCHAR2,
chunks          OUT NUMBER,
dobj         IN OUT NUMBER,
service_name IN     VARCHAR2,
svc_id       IN OUT NUMBER);
TBD
 
SETREMOTECHUNKSTATE (new 23ai)
Set state of a chunk with given shardspace_id in the remote shard of a chunks table dbms_gsm_dbadmin.setRemoteChunkState(
chunk_number IN NUMBER,
ssid         IN NUMBER,
chunk_state  IN NUMBER);
TBD
 
SETSPLITPSETSTATUS (new 23ai)
Set the status value for in a partition_set table on catalog db from shard dbms_gsm_dbadmin.setSplitPsetStatus(status IN NUMBER);
TBD
 
SETSTBYPARAM (new 23ai)
Execute modifications of parameters on behalf of a standby dbms_gsm_dbadmin.setStbyParam(
pname    IN VARCHAR2,
pvalue   IN VARCHAR2,
pdb_id   IN BINARY_INTEGER,
db_uname IN VARCHAR2)
ACCESSIBLE BY (TRIGGER stbyparam_insert);
TBD
 
SETUPMETADATACURSOR
Undocumented dbms_gsm_dbadmin.setupMetadataCursor(
pin     IN BOOLEAN DEFAULT TRUE,
cleanup IN BOOLEAN DEFAULT TRUE);
exec dbms_gsm_dbadmin.setupMetadataCursor(TRUE, FALSE);

PL/SQL procedure successfully completed.
 
SETUPRU (new 23ai)
Undocumented

Overload 1		 dbms_gsm_dbadmin.setupRU(
ru_id      IN  NUMBER,
peer_dbs   IN  dbnum_list,
err_num    OUT NUMBER,
err_string OUT VARCHAR2,
makeLinks  IN  NUMBER DEFAULT dbms_gsm_common.isFalse);
TBD
Overload 2 dbms_gsm_dbadmin.setupRU(
ru_id         IN  NUMBER,
peer_dbs      IN  dbnum_list,
peer_conn_str IN  connect_list,
peer_pwds     IN  pwd_list,
err_num       OUT NUMBER,
err_string    OUT VARCHAR2);
TBD
 
SETUPSESSIONCONTEXT
Undocumented dbms_gsm_dbadmin.setupSessionContext;
exec dbms_gsm_dbadmin.setupSessionContext;

PL/SQL procedure successfully completed.
 
SNRDONEBARDDL (new 23ai)
Lets shards know a core DDL is complete (whether succeeded or not) dbms_gsm_dbadmin.snrDoneBarDDL(
ddl_id IN BINARY_INTEGER,
status IN BINARY_INTEGER);
TBD
 
SNRSENDDDLCOMPLLCR (new 23ai)
Sends a DDL Completion Marker LCR dbms_gsm_dbadmin.snrSendDDLComplLCR(
ddl_id       IN BINARY_INTEGER,
flags        IN BINARY_INTEGER,
leader_id    IN BINARY_INTEGER,
obj_bar_vers IN BINARY_INTEGER,
obj_name     IN VARCHAR2,
oname_len    IN BINARY_INTEGER,
sch_name     IN VARCHAR2,
sname_len    IN BINARY_INTEGER);
TBD
 
SNRSYNCPOINT (new 23ai)
Invokes a sync point on the leader for SNR replication dbms_gsm_dbadmin.snrSyncPoint(ddl_id IN BINARY_INTEGER,
ru_id IN  BINARY_INTEGER,
err   OUT BINARY_INTEGER);
TBD
 
SNRUPDATERUCMPLID (new 23ai)
Updates the latest barrier DDL ID in RUs dbms_gsm_dbadmin.snrUpdateRUCmplId(ddl_id IN BINARY_INTEGER);
TBD
 
SPLITCHUNK
Undocumented dbms_gsm_dbadmin.splitChunk(
a_chunk_id      IN BINARY_INTEGER,
target_chunk_id IN BINARY_INTEGER,
a_shardspace_id IN BINARY_INTEGER);
TBD
 
SPLITPSETFILLCATTSSETTBL (new 23ai)
Populate the ts_set_table on catalog as part of split partitionset operation dbms_gsm_dbadmin.splitPsetFillCatTSSetTbl;
TBD
 
SPLITPSETFILLTSSETTBL (new 23ai)
Populatest the target shard ts_set_table as part of split partitionset operation dbms_gsm_dbadmin.splitPsetFillTSSetTbl;
TBD
 
SPLITPSETPKPOSTPROC (new 23ai)
Post processing to split a partitionset for the primary key indices for all tables in a chunk dbms_gsm_dbadmin.splitPsetPkPostProc(chunk_number IN NUMBER);
TBD
 
SPLITPSETPOSTPROCREMOTE (new 23ai)
Post processing to split a partitionset in the source shard dbms_gsm_dbadmin.splitPsetPostProcRemote(chunk_num IN NUMBER);
TBD
 
SPLITPSETTBLPOSTPROC (new 23ai)
Post processing to split the partitionset for a table dbms_gsm_dbadmin.splitPsetTblPostProc(
t_name    IN VARCHAR2,
p_name    IN VARCHAR2,
owner     IN VARCHAR2,
chunk_num IN NUMBER);
TBD
 
SPLITPSETTBLSPCPOSTPROC (new 23ai)
Post processing for split partitionset for a tablespaces dbms_gsm_dbadmin.splitPsetTblSpcPostProc(chunk_num IN NUMBER);
TBD
 
SPLIT_PSET_FINISH_CAT (new 23ai)
Invokes the split_pset_finish_cat C function on catalog db dbms_gsm_dbadmin.split_pset_finish_cat(
ddl_id           IN BINARY_INTEGER,
local_keys       IN BINARY_INTEGER,
ptype            IN BINARY_INTEGER,
old_pset_name    IN VARCHAR2,
change_pset_name IN VARCHAR2,
source_ssid      IN BINARY_INTEGER,
new_pset_name    IN VARCHAR2,
target_ssid      IN BINARY_INTEGER,
family_id        IN BINARY_INTEGER);
TBD
 
SPLIT_PSET_RMDBLINK (new 23ai)
InvokeS the split_pset_rmdblink C function on catalog db dbms_gsm_dbadmin.split_pset_rmdblink(
chunk_num IN BINARY_INTEGER,
ssid      IN BINARY_INTEGER);
TBD
 
SPSLOGCNTTGTCHUNKS (new 23ai)
Undocumented dbms_gsm_dbadmin.SPSLogCntTgtChunks(
ddl_id IN NUMBER,
db_num IN NUMBER)
RETURN BINARY_INTEGER;
TBD
 
SPSLOGINRECOVERY (new 23ai)
Undocumented dbms_gsm_dbadmin.SPSLogInRecovery(
ddl_id IN NUMBER,
db_num IN NUMBER) RETURN BOOLEAN;
TBD
 
SPSLOGISCOMPLETE (new 23ai)
Undocumented dbms_gsm_dbadmin.SPSLogIsComplete(
ddl_id IN NUMBER,
ssid   IN NUMBER)
RETURN BOOLEAN;
TBD
 
SPSLOGLASTSRCCHUNK (new 23ai)
Undocumented dbms_gsm_dbadmin.SPSLogLastSrcChunk(
ddl_id IN NUMBER,
db_num IN NUMBER) RETURN NUMBER;
TBD
 
SPSLOGLASTTGTCHUNK (new 23ai)
Undocumented dbms_gsm_dbadmin.SPSLogLastTgtChunk(ddl_id IN NUMBER) RETURN NUMBER;
TBD
 
SPSLOGMARKCOMPLETE (new 23ai)
Undocumented dbms_gsm_dbadmin.SPSLogMarkComplete(
ddl_id IN NUMBER,
ssid   IN NUMBER);
TBD
 
SPSLOGPARTCOMPLETE (new 23ai)
Undocumented dbms_gsm_dbadmin.SPSLogPartComplete(ddl_id IN NUMBER,
chunk_id IN NUMBER,
oper     IN NUMBER,
tname    IN VARCHAR2,
pname    IN VARCHAR2,
spname   IN VARCHAR2) RETURN BOOLEAN;
TBD
 
SPSLOGPARTWRITE (new 23ai)
Undocumented dbms_gsm_dbadmin.SPSLogPartWrite(
ddl_id   IN NUMBER,
chunk_id IN NUMBER,
oper     IN NUMBER,
tname    IN VARCHAR2,
pname    IN VARCHAR2,
spname   IN VARCHAR2);
TBD
 
SPSLOGRECOVERYSTATE (new 23ai)
Undocumented dbms_gsm_dbadmin.SPSLogRecoveryState RETURN reco_stat_t;
TBD
 
SPSLOGSRCCHUNKSTATE (new 23ai)
Undocumented dbms_gsm_dbadmin.SPSLogSrcChunkState(
ddl_id IN NUMBER,
db_num IN NUMBER)
RETURN NUMBER;
TBD
 
SPSLOGTRUNCATE (new 23ai)
Undocumented dbms_gsm_dbadmin.SPSLogTruncate;
TBD
 
SPSLOGWRITE (new 23ai)
Undocumented dbms_gsm_dbadmin.SPSLogWrite(
ddl_id     IN NUMBER,
chunk_id   IN NUMBER,
db_num     IN NUMBER,
shard_type IN VARCHAR2,
oper       IN NUMBER,
commit     IN BOOLEAN);
TBD
 
SSIDTSEXISTS (new 23ai)
Checks if there are any tablespace sets in shard_ts table for a shardspace id dbms_gsm_dbadmin.ssidtsExists(ssid IN NUMBER) RETURN NUMBER;
TBD
 
STARTRUELECTION (new 23ai)
Undocumented dbms_gsm_dbadmin.startRUElection(
ru_id     IN BINARY_INTEGER,
tmout     IN BINARY_INTEGER default 0,
gdsctl_id IN NUMBER DEFAULT 0);
TBD
 
STARTSERVICE
Start a database service dbms_gsm_dbadmin.startService(
service_name IN VARCHAR2,
inst_list    IN VARCHAR2 DEFAULT NULL);
exec gsmadmin_internal.dbms_gsm_dbadmin.startService('MLIBSVC', '1');
     *
ORA-44304: service MLIBSVC does not exist
 
STOPRU (new 23ai)
Undocumented dbms_gsm_dbadmin.stopRU(ru_id IN BINARY_INTEGER);
TBD
 
STOPSERVICE
Stop a database service dbms_gsm_dbadmin.stopService(
service_name IN VARCHAR2,
force        IN NUMBER   DEFAULT dbms_gsm_common.isFalse,
options      IN VARCHAR2 DEFAULT NULL);
exec gsmadmin_internal.dbms_gsm_dbadmin.stopService('MLIBSVC');
     *
ORA-44304: service MLIBSVC does not exist
 
STRTOLIST (new 23ai)
Converts a VARCHAR2 string to a name_list_type dbms_gsm_dbadmin.strtolist(lstring IN VARCHAR2) RETURN name_list_type;
TBD
 
SYNC
Execute database-side modifications dbms_gsm_dbadmin.sync(
dsc      IN OUT database_dsc_t,
warnings    OUT warning_list_t);
TBD
 
SYNCALLRUPARAMS (new 23ai)
Undocumented dbms_gsm_dbadmin.syncAllRUParams(force IN NUMBER DEFAULT dbms_gsm_common.isFalse);
TBD
 
SYNCCOMPATIBLE (new 23ai)
Pulls the latest compatible settings from the catalog and updates the shard's compatible settings if appropriate dbms_gsm_dbadmin.syncCompatible;
exec gsmadmin_internal.dbms_gsm_dbadmin.syncCompatible;
     *
ORA-045568: database link to catalog is invalid
 
SYNCDDLPARAMETER
Undocumented dbms_gsm_dbadmin.syncDDLParameter;
exec gsmadmin_internal.dbms_gsm_dbadmin.syncDDLParameter;

PL/SQL procedure successfully completed.
 
SYNCRU (new 23ai)
Undocumented dbms_gsm_dbadmin.syncRU(ru_id IN BINARY_INTEGER,
gdsctl_id IN NUMBER DEFAULT 0,
dolocal   IN NUMBER DEFAULT dbms_gsm_common.isTrue);
TBD
 
TABEXISTS (new 23ai)
Returns 1 if the table exists: Else 0 dbms_gsm_dbadmin.tabExists(
owner  IN VARCHAR2,
t_name IN VARCHAR2)
RETURN NUMBER;
TBD
 
TMP_ADDPSET (new 23ai)
Inserts partition_set values into the local dummy tmp table dbms_gsm_dbadmin.tmp_addpset(
old_pset_name IN VARCHAR2,
pset_name     IN VARCHAR2,
inkeys        IN VARCHAR2,
tset_name     IN VARCHAR2,
bhibnd        IN VARCHAR2,
owner         IN VARCHAR2);
TBD
 
TSEXISTS (new 23ai)
Returns 1 if the tablespace exists: Else 0 dbms_gsm_dbadmin.tsExists(ts_name IN VARCHAR2) RETURN NUMBER;
SELECT gsmadmin_internal.dbms_gsm_dbadmin.tsExists('USERS');

GSMADMIN_INTERNAL.DBMS_GSM_DBADMIN.TSEXISTS('USERS')
----------------------------------------------------
                                                   1
 
UPDATECATDDLSTATUS (new 23ai)
Undocumented dbms_gsm_dbadmin.updateCatDDLStatus(
ddl_id IN NUMBER,
ru_id  IN NUMBER,
status IN NUMBER);
TBD
 
UPDATEDDLSTATUS (new 23ai)
Undocumented dbms_gsm_dbadmin.updateDDLStatus(
i_ddl_id IN NUMBER,
i_ru_id  IN NUMBER,
i_status IN NUMBER,
local    IN NUMBER);
TBD
 
UPDATEMETADATADISTRIB (new 23ai)
Undocumented dbms_gsm_dbadmin.updateMetadataDistrib(
oid       IN BINARY_INTEGER,
isOGG     IN BOOLEAN,
sh_method IN NUMBER,
ruMove IN BOOLEAN default FALSE);
TBD
 
UPDATESHDDDLSTATUS (new 23ai)
Undocumented dbms_gsm_dbadmin.updateShdDDLStatus(
ddl_id IN BINARY_INTEGER,
status IN BINARY_INTEGER);
TBD
 
UPDENDCHUNKSPLITPSETSTAT (new 23ai)
Updates a row for chunk operation complete in v$split_pset_stat table dbms_gsm_dbadmin.updEndChunkSplitPsetStat(
ddlid     IN NUMBER,
owner     IN VARCHAR2,
rt_name   IN VARCHAR2,
chunk_num IN NUMBER);
TBD
 
UPDSPSMONBACKUP0 (new 23ai)
Undocumented dbms_gsm_dbadmin.updSPSMonBackup0(
ddlid     IN NUMBER,
owner     IN VARCHAR2,
tname     IN VARCHAR2,
chunk_num IN NUMBER);
TBD
 
UPDSPSMONBACKUP1 (new 23ai)
Undocumented dbms_gsm_dbadmin.updSPSMonBackup1(
ddlid     IN NUMBER,
owner     IN VARCHAR2,
tname     IN VARCHAR2,
chunk_num IN NUMBER);
TBD
 
UPDSPSMONCOMPLETE (new 23ai)
Undocumented dbms_gsm_dbadmin.updSPSMonComplete(
ddlid     IN NUMBER,
owner     IN VARCHAR2,
tname     IN VARCHAR2,
chunk_num IN NUMBER);
TBD
 
UPDSPSMONIMPORT (new 23ai)
Undocumented dbms_gsm_dbadmin.updSPSMonImport(
ddlid     IN NUMBER,
owner     IN VARCHAR2,
tname     IN VARCHAR2,
chunk_num IN NUMBER);
TBD
 
UPDSPSMONTRANSFER0 (new 23ai)
Undocumented dbms_gsm_dbadmin.updSPSMonTransfer0(
ddlid     IN NUMBER,
owner     IN VARCHAR2,
tname     IN VARCHAR2,
chunk_num IN NUMBER);
TBD
 
UPDSPSMONTRANSFER1 (new 23ai)
Undocumented dbms_gsm_dbadmin.updSPSMonTransfer1(ddlid IN NUMBER,
owner     IN VARCHAR2,
tname     IN VARCHAR2,
chunk_num IN NUMBER);
TBD
 
UPDTSCHUNKSPLITPSETSTAT (new 23ai)
Updates a row for chunk operation done tablespace in v$split_pset_stat table dbms_gsm_dbadmin.updTSChunkSplitPsetStat(
ddlid     IN NUMBER,
owner     IN VARCHAR2,
rt_name   IN VARCHAR2,
ts_name   IN VARCHAR2,
chunk_num IN NUMBER);
TBD
 
VALIDATEDATABASE (new 23ai)
Validate database existence and return local DB info

Overload 1		 dbms_gsm_dbadmin.validateDatabase(
dbpool         IN  VARCHAR2,
db_unique_name OUT VARCHAR2,
instances      OUT NUMBER,
cloud_name     IN  VARCHAR2 DEFAULT NULL);
TBD
Overload 2 dbms_gsm_dbadmin.validateDatabase(
dbpool         IN  VARCHAR2,
db_unique_name OUT VARCHAR2);
TBD
 
VALIDATENATIVEREPLICATION
Undocumented dbms_gsm_dbadmin.validateNativeReplication;
exec gsmadmin_internal.dbms_gsm_dbadmin.validateNativeReplication;

PL/SQL procedure successfully completed.

Related Topics
Built-in Functions
Built-in Packages
DBMS_GSM_ALERTS
DBMS_GSM_CLOUDADMIN
DBMS_GSM_COMMON
DBMS_GSM_DDL
DBMS_GSM_FIX
DBMS_GSM_FIXED
DBMS_GSM_NOPRIV
DBMS_GSM_POOLADMIN
DBMS_GSM_SEC
DBMS_GSM_UTILITY
DBMS_GSM_XDB
DBMS_SERVICE
EXCHANGE
What's New In 21c
What's New In 26ai