Oracle DBMS_CAPTURE_ADM_INTERNAL
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 Internal utilities provideing programs for starting, stopping, and configuring the Streams capture process. The source of the captured changes is the redo logs, and the repository for the captured changes is a queue.
AUTHID DEFINER
Dependencies SELECT name FROM dba_dependencies WHERE referenced_name = 'DBMS_CAPTURE_ADM_INTERNAL'
UNION
SELECT referenced_name FROM dba_dependencies WHERE name = 'DBMS_CAPTURE_ADM_INTERNAL'
ORDER BY 1;

Returns 68 objects
Documented No
First Available Not known
Security Model Owned by SYS with no privileges granted
Source {ORACLE_HOME}/rdbms/admin/prvthcap.plb
{ORACLE_HOME}/rdbms/admin/prvtbcap.plb
Subprograms
ABORT_GLOBAL_INST GET_SOURCE_ROOT PREPARE_SCHEMA_INST_CDB
ABORT_GLOBAL_INSTANTIATION INCLUDE_EXTRA_ATTRIBUTE PREPARE_SCHEMA_TABLES
ABORT_GLOBAL_INST_ONE_PDB IS_CAPTURE_EXISTS PREPARE_SYNC_INSTANTIATION
ABORT_SCHEMA_INSTANTIATION IS_DOWNSTREAM_CAPTURE PREPARE_TABLE_INST
ABORT_SCHEMA_INST_CDB IS_EXISTING_DOWNSTREAM_CAP PREPARE_TABLE_INSTANTIATION
ABORT_TABLE_INSTANTIATION IS_GOLDENGATE_CAPTURE PREPARE_TABLE_INST_CDB
ABORT_TABLE_INST_CDB IS_NEW_CAP_INSTANCE_ALLOWED REPLACE_DICTIONARY
ADD_LOGFILE IS_SYNC_CAPTURE SET_XOUT_PARAMS
ALTER_CAPTURE IS_USE_DBLINK STORE_PREPARE_INFO
BUILD PREPARE_DDL SUSPEND_CAPTURE
CREATE_CAPTURE PREPARE_GLOBAL_INST UPDATE_PREPARE_DDL
DROP_CAPTURE PREPARE_GLOBAL_INSTANTIATION VALIDATE_PREPARE_TABLE
ENFORCE_CHECKPOINT_RETENTION PREPARE_GLOBAL_INST_ONE_PDB WAIT_FOR_INFLIGHT_TXN
GET_SOURCE_DATABASE PREPARE_SCHEMA_INSTANTIATION  
 
ABORT_GLOBAL_INST
Undocumented dbms_capture_adm_internal.abort_global_inst(canon_invoker IN VARCHAR2);
TBD
 
ABORT_GLOBAL_INSTANTIATION
Undocumented dbms_capture_adm_internal.abort_global_instantiation(
canon_invoker IN VARCHAR2,
container     IN VARCHAR2);
TBD
 
ABORT_GLOBAL_INST_ONE_PDB
Undocumented dbms_capture_adm_internal.abort_global_inst_one_pdb(
pdb_name      IN VARCHAR2,
canon_invoker IN VARCHAR2);
TBD
 
ABORT_SCHEMA_INSTANTIATION
Undocumented dbms_capture_adm_internal.abort_schema_instantiation(
schema_name   IN VARCHAR2,
canon_invoker IN VARCHAR2,
container     IN VARCHAR2);
TBD
 
ABORT_SCHEMA_INST_CDB
Undocumented dbms_capture_adm_internal.abort_schema_inst_cdb(
schema_name   IN VARCHAR2,
pdb_name      IN VARCHAR2,
canon_invoker IN VARCHAR2);
TBD
 
ABORT_TABLE_INSTANTIATION
Undocumented dbms_capture_adm_internal.abort_table_instantiation(
table_name    IN VARCHAR2,
canon_invoker IN VARCHAR2,
container     IN VARCHAR2);
TBD
 
ABORT_TABLE_INST_CDB
Undocumented dbms_capture_adm_internal.abort_table_inst_cdb(
table_name    IN VARCHAR2,
pdb_name      IN VARCHAR2,
canon_invoker IN VARCHAR2);
TBD
 
ADD_LOGFILE
Undocumented dbms_capture_adm_internal.add_logfile(
capture_name IN VARCHAR2,
file_name    IN VARCHAR2,
is_internal  IN BOOLEAN);
TBD
 
ALTER_CAPTURE
Undocumented dbms_capture_adm_internal.alter_capture(
capture_name              IN VARCHAR2,
canon_invoker             IN VARCHAR2,
rule_set_name             IN VARCHAR2,
remove_rule_set           IN BOOLEAN,
start_scn                 IN NUMBER,
use_database_link         IN BOOLEAN,
first_scn                 IN NUMBER,
negative_rule_set_name    IN VARCHAR2,
remove_negative_rule_set  IN BOOLEAN,
capture_user              IN VARCHAR2,
checkpoint_retention_time IN NUMBER,
start_time                IN TIMESTAMP,
oldest_scn                IN NUMBER,
processed_lwm_scn         IN NUMBER,
capproc_flags             IN BINARY_INTEGER);
TBD
 
BUILD
Undocumented dbms_capture_adm_internal.build(
first_scn              OUT NUMBER,
wait_for_inflight_txns IN  VARCHAR2);
TBD
 
CREATE_CAPTURE
Undocumented dbms_capture_adm_internal.create_capture(
queue_name                IN VARCHAR2,
capture_name              IN VARCHAR2,
canon_invoker             IN VARCHAR2,
rule_set_name             IN VARCHAR2,
start_scn                 IN NUMBER,
source_database           IN VARCHAR2,
use_database_link         IN BOOLEAN,
first_scn                 IN NUMBER,
logfile_assignment        IN VARCHAR2,
i_customer_id             IN BINARY_INTEGER,
negative_rule_set_name    IN VARCHAR2,
start_date                IN DATE,
end_date                  IN DATE,
capture_user              IN VARCHAR2,
checkpoint_retention_time IN NUMBER,
sync_capture              IN BOOLEAN,
enable_trigger            IN BOOLEAN,
ckpt_fre                  IN BOOLEAN,
start_time                IN TIMESTAMP,
wait_for_inflight_txns    IN BOOLEAN,
capproc_flags             IN BINARY_INTEGER,
enable_procedure          IN BOOLEAN,
source_root_name          IN VARCHAR2,
clone_capture_name        IN VARCHAR2,
share_sid                 IN NUMBER);
TBD
 
DROP_CAPTURE
Undocumented

Overload 1		 dbms_capture_adm_internal.drop_capture(
capture_name           IN VARCHAR2,
drop_unused_rule_sets  IN BOOLEAN,
canon_invoker          IN VARCHAR2);
TBD
Overload 2 dbms_capture_adm_internal.drop_capture(
capture_name  IN VARCHAR2,
canon_invoker IN VARCHAR2);
TBD
 
ENFORCE_CHECKPOINT_RETENTION
Undocumented dbms_capture_adm_internal.enforce_checkpoint_retention(
capture_name  IN VARCHAR2,
ckpt_per_day  IN NUMBER,
all_ckpt_keep IN NUMBER);
TBD
 
GET_SOURCE_DATABASE
Undocumented dbms_capture_adm_internal.get_source_database(canon_capture_name IN VARCHAR2)
RETURN VARCHAR2;
TBD
 
GET_SOURCE_ROOT
Undocumented dbms_capture_adm_internal.get_source_root(canon_capture_name IN VARCHAR2)
RETURN VARCHAR2;
TBD
 
INCLUDE_EXTRA_ATTRIBUTE
Undocumented dbms_capture_adm_internal.include_extra_attribute(
capture_name   IN VARCHAR2,
attribute_name IN VARCHAR2,
include        IN BOOLEAN);
TBD
 
IS_CAPTURE_EXISTS
Returns TRUE if the named capture process exists dbms_capture_adm_internal.is_capture_exists(canon_capture_name IN VARCHAR2)
RETURN BOOLEAN;
TBD
 
IS_DOWNSTREAM_CAPTURE
Returns TRUE if the process is a downstream capture dbms_capture_adm_internal.is_downstream_capture(
canon_source_database_name IN VARCHAR2,
canon_source_root_name     IN VARCHAR2)
RETURN BOOLEAN;
TBD
 
IS_EXISTING_DOWNSTREAM_CAP
Returns TRUE if a downstream capture process currently exists dbms_capture_adm_internal.is_existing_downstream_cap(canon_capture_name IN VARCHAR2)
RETURN BOOLEAN;
TBD
 
IS_GOLDENGATE_CAPTURE
Returns TRUE if the existing process is a GoldenGate capture dbms_capture_adm_internal.is_goldengate_capture(canon_capture_name IN VARCHAR2)
RETURN BOOLEAN;
TBD
 
IS_NEW_CAP_INSTANCE_ALLOWED (new 23ai)
Undocumented dbms_capture_adm_internal.is_new_cap_instance_allowed RETURN BOOLEAN;
BEGIN
  IF dbms_capture_adm_internal.is_new_cap_instance_allowedTHEN
    dbms_output.put_line('T');
  ELSE
    dbms_output.put_line('F');
END;
/
T

PL/SQL procedure successfully completed.
 
IS_SYNC_CAPTURE
Returns TRUE if the process is a synchronous capture dbms_capture_adm_internal.is_sync_capture(
capture_name IN VARCHAR2,
is_canon_name IN BOOLEAN)
RETURN BOOLEAN;
TBD
 
IS_USE_DBLINK
Returns TRUE if the capture process uses a Database Link dbms_capture_adm_internal.is_use_dblink(canon_capture_name IN VARCHAR2) RETURN BOOLEAN;
TBD
 
PREPARE_DDL
Undocumented dbms_capture_adm_internal.prepare_ddl(
canon_name     IN VARCHAR2,
supp_log_level IN BINARY_INTEGER);
TBD
 
PREPARE_GLOBAL_INST
Undocumented dbms_capture_adm_internal.prepare_global_inst(
canon_invoker          IN VARCHAR2,
supp_log_level         IN BINARY_INTEGER,
wait_for_inflight_txns IN BOOLEAN);
TBD
 
PREPARE_GLOBAL_INSTANTIATION
Undocumented dbms_capture_adm_internal.prepare_global_instantiation(
canon_invoker          IN VARCHAR2,
supp_log_level         IN BINARY_INTEGER,
wait_for_inflight_txns IN BOOLEAN,
container              IN VARCHAR2);
TBD
 
PREPARE_GLOBAL_INST_ONE_PDB
Undocumented dbms_capture_adm_internal.prepare_global_inst_one_pdb(
pdb_name               IN VARCHAR2,
canon_invoker          IN VARCHAR2,
supp_log_level         IN BINARY_INTEGER,
wait_for_inflight_txns IN BOOLEAN);
TBD
 
PREPARE_SCHEMA_INSTANTIATION
Undocumented dbms_capture_adm_internal.prepare_schema_instantiation(
schema_name     IN VARCHAR2,
canon_invoker   IN VARCHAR2,
supp_log_level  IN BINARY_INTEGER,
synchronization IN VARCHAR2,
container       IN VARCHAR2);
TBD
 
PREPARE_SCHEMA_INST_CDB
Undocumented dbms_capture_adm_internal.prepare_schema_inst_cdb(
schema_name     IN VARCHAR2,
pdb_name        IN VARCHAR2,
canon_invoker   IN VARCHAR2,
supp_log_level  IN BINARY_INTEGER,
synchronization IN VARCHAR2);
TBD
 
PREPARE_SCHEMA_TABLES
Undocumented dbms_capture_adm_internal.prepare_schema_tables(
canon_schema_name IN VARCHAR2,
locking           IN BOOLEAN,
container         IN VARCHAR2);
TBD
 
PREPARE_SYNC_INSTANTIATION
Undocumented dbms_capture_adm_internal.prepare_sync_instantiation(
table_names   IN sys.dbms_utility.uncl_array,
canon_invoker IN VARCHAR2)
RETURN NUMBER;
TBD
 
PREPARE_TABLE_INST
Undocumented dbms_capture_adm_internal.prepare_table_inst(
canon_owner                IN VARCHAR2,
canon_table_name           IN VARCHAR2,
supplemental_logging_level IN BINARY_INTEGER,
locking                    IN BOOLEAN,
container                  IN VARCHAR2);
TBD
 
PREPARE_TABLE_INSTANTIATION
Undocumented dbms_capture_adm_internal.prepare_table_instantiation(
table_name      IN VARCHAR2,
canon_invoker   IN VARCHAR2,
supp_log_level  IN BINARY_INTEGER,
synchronization IN VARCHAR2,
container       IN VARCHAR2);
TBD
 
PREPARE_TABLE_INST_CDB
Undocumented dbms_capture_adm_internal.prepare_table_inst_cdb(
table_name      IN VARCHAR2,
pdb_name        IN VARCHAR2,
canon_invoker   IN VARCHAR2,
supp_log_level  IN BINARY_INTEGER,
synchronization IN VARCHAR2);
TBD
 
REPLACE_DICTIONARY
Undocumented dbms_capture_adm_internal.prepare_table_inst_cdb(source_database IN VARCHAR2);
TBD
 
SET_XOUT_PARAMS
Undocumented dbms_capture_adm_internal.set_xout_params(
canon_capture_name IN VARCHAR2,
xout_exists        IN BOOLEAN);
TBD
 
STORE_PREPARE_INFO
Undocumented dbms_capture_adm_internal.store_prepare_info(
canon_name     IN VARCHAR2,
supp_log_level IN BINARY_INTEGER);
TBD
 
SUSPEND_CAPTURE
Undocumented dbms_capture_adm_internal.suspend_capture(
capture_name IN VARCHAR2,
suspend      IN BOOLEAN);
TBD
 
UPDATE_PREPARE_DDL
Undocumented dbms_capture_adm_internal.update_prepare_ddl(canon_invoker IN VARCHAR2);
TBD
 
VALIDATE_PREPARE_TABLE
Undocumented dbms_capture_adm_internal.validate_prepare_table(
canon_owner      IN VARCHAR2,
canon_table_name IN VARCHAR2);
TBD
 
WAIT_FOR_INFLIGHT_TXN
Undocumented dbms_capture_adm_internal.wait_for_inflight_txn(
current_scn     IN NUMBER,
procname        IN VARCHAR2,
local_container IN BOOLEAN);
TBD

Related Topics
ARCHIVELOG Mode
Built-in Functions
Built-in Packages
Database Security
DBMS_APPLY_ADM
DBMS_CAPTURE_ADM
DBMS_CAPTURE_ADM_INTERNAL
DBMS_CAPTURE_ADM_IVK
DBMS_CAPTURE_PROCESS
DBMS_CAPTURE_SWITCH_ADM
DBMS_CAPTURE_SWITCH_INTERNAL
DBMS_STREAMS
DBMS_STREAMS_ADM
DBMS_STREAMS_AUTH


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