Oracle DBMS_CAPTURE_ADM_INTERNAL
Version 21c

General Information
Library Note Morgan's Library Page Header
Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.
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
DBA_APPLY DBMS_SQL EXPDEPACT$
DBA_CAPTURE DBMS_STANDARD GLOBAL_NAME
DBA_CAPTURE_PARAMETERS DBMS_STREAMS_ADM GOLDENGATE$_CONTAINER_RULES
DBA_OBJECTS DBMS_STREAMS_ADM_IVK GV$ARCHIVED_LOG
DBA_REGISTERED_ARCHIVED_LOG DBMS_STREAMS_ADM_UTL LOGMNR_LOG$
DBA_USERS DBMS_STREAMS_ADM_UTL_INVOK OBJ$
DBMS_APPLY_ADM_INTERNAL DBMS_STREAMS_AUTO_INT PLITBLM
DBMS_ASSERT DBMS_STREAMS_DECL STREAMS$_CAPTURE_PROCESS
DBMS_CAPTURE_ADM DBMS_STREAMS_MT STREAMS$_CAPTURE_SERVER
DBMS_CAPTURE_ADM_IVK DBMS_STREAMS_RPC STREAMS$_PREPARE_DDL
DBMS_CAPTURE_PROCESS DBMS_STREAMS_RPC_INTERNAL STREAMS$_PREPARE_OBJECT
DBMS_FLASHBACK DBMS_STREAMS_SM STREAMS$_PROCESS_PARAMS
DBMS_LOCK DBMS_SYSTEM TAB$
DBMS_LOGMNR_D DBMS_SYS_ERROR TIMESTAMP_TO_SCN
DBMS_LOGMNR_INTERNAL DBMS_UTILITY USER$
DBMS_LOGREP_IMP DBMS_XSTREAM_ADM V$DATABASE
DBMS_LOGREP_LIB DBMS_XSTREAM_ADM_INTERNAL V$DB_PIPES
DBMS_LOGREP_UTIL DBMS_XSTREAM_ADM_UTL _DBA_CAPTURE
DBMS_LOGREP_UTIL_INVOK DBMS_XSTREAM_GG_ADM _DBA_GGXSTREAM_INBOUND
DBMS_PIPE DBMS_XSTREAM_UTL_IVK _DBA_GGXSTREAM_OUTBOUND
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
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_SYNC_INSTANTIATION
Undocumented dbms_capture_adm_internal.abort_sync_instantiation(
table_names   IN sys.dbms_utility.uncl_array,
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
 
CREATE_SYNC_CAPTURE
Undocumented dbms_capture_adm_internal.create_sync_capture(
queue_name     IN VARCHAR2,
capture_name   IN VARCHAR2,
canon_invoker  IN VARCHAR2,
rule_set_name  IN VARCHAR2,
capture_user   IN VARCHAR2,
enable_trigger IN BOOLEAN);
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_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_INTERNAL
DBMS_CAPTURE_ADM_IVK
DBMS_CAPTURE_SWITCH_ADM
DBMS_STREAMS
DBMS_STREAMS_ADM
DBMS_STREAMS_AUTH
What's New In 19c
What's New In 20c-21c

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