Oracle DBMS_STREAMS_TBS_INT
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 Streams Tablespace Management Utilities
AUTHID DEFINER
Dependencies
ALL_DIRECTORIES DBMS_FILE_GROUP_UTL_INVOK DBMS_STREAMS_TBS_INT_INVOK
DBA_DATA_FILES DBMS_FILE_TRANSFER DBMS_STREAMS_TBS_LIB
DBA_DIRECTORIES DBMS_LOGREP_UTIL DBMS_SYSTEM
DBA_FILE_GROUP_EXPORT_INFO DBMS_STANDARD DBMS_SYS_ERROR
DBA_FILE_GROUP_FILES DBMS_STREAMS_ADM_UTL DBMS_UTILITY
DBMS_BACKUP_RESTORE DBMS_STREAMS_DECL KU$_STATUS
DBMS_FILE_GROUP DBMS_STREAMS_MT V$DATABASE
DBMS_FILE_GROUP_DECL DBMS_STREAMS_RPC V$TRANSPORTABLE_PLATFORM
DBMS_FILE_GROUP_UTL DBMS_STREAMS_TABLESPACE_ADM  
Data Types tbs_filename_fileid_type
Documented No
First Available Not known
Security Model Owned by SYS with no privileges granted.

As shown in demos below this package is protected from direct access with an Accessible By clause.
Source {ORACLE_HOME}/rdbms/admin/prvthsts.plb
{ORACLE_HOME}/rdbms/admin/prvtbsts.plb
Subprograms
 
CANON
Undocumented dbms_streams_tbs_int.canon(
token IN VARCHAR2,
len   IN VARCHAR2)
RETURN VARCHAR2;
TBD
 
CHECK_ASM
Undocumented dbms_streams_tbs_int.check_asm(directory_object IN VARCHAR2) RETURN BOOLEAN;
TBD
 
CHECK_CDB
Undocumented dbms_streams_tbs_int.check_cdb;
TBD
 
CHECK_FILE_EXISTS
Undocumented dbms_streams_tbs_int.check_file_exists(fq_file_name IN VARCHAR2) RETURN BOOLEAN;
TBD
 
COMBINE_DIR_AND_FILE
Undocumented dbms_streams_tbs_int.combine_dir_and_file(
directory_object IN VARCHAR2,
file_name        IN VARCHAR2)
RETURN VARCHAR2;
TBD
 
COMPARE_PATH_NAMES
Undocumented dbms_streams_tbs_int.compare_path_names(
path1 IN VARCHAR2,
path2 IN VARCHAR2)
RETURN BOOLEAN;
TBD
 
CONVERT_FILE
Undocumented dbms_streams_tbs_int.convert_file(
input_filename     IN VARCHAR2,
input_filenumber   IN BINARY_INTEGER,
input_platform_id  IN BINARY_INTEGER,
output_filename    IN VARCHAR2,
output_platform_id IN BINARY_INTEGER,
convert_at_source  IN BOOLEAN);
TBD
 
CONVERT_FILE_AT_SOURCE
Undocumented dbms_streams_tbs_int.convert_file_at_source(
input_dir_object     IN  VARCHAR2,
input_filenumber     IN  BINARY_INTEGER,
input_platform_id    IN  BINARY_INTEGER,
output_dir_object    IN  VARCHAR2,
output_filename      IN  VARCHAR2,
output_platform_id   IN  BINARY_INTEGER,
convert_fq_file_name OUT VARCHAR2);
TBD
 
CONVERT_PLATFORM_TO_ID
Undocumented dbms_streams_tbs_int.convert_platform_to_id(platform IN VARCHAR2) RETURN BINARY_INTEGER;
TBD
 
DEFAULT_FILE_NAME
Undocumented dbms_streams_tbs_int.default_file_name(
file_name      IN VARCHAR2,
base_file_name IN VARCHAR2,
extension      IN VARCHAR2,
is_asm         IN BOOLEAN)
RETURN VARCHAR2;
TBD
 
DETERMINE_CALL_TRACING
Undocumented dbms_streams_tbs_int.determine_call_tracing RETURN BOOLEAN;
TBD
 
DUMP_ERROR
Undocumented dbms_streams_tbs_int.dump_error(
sql_code IN NUMBER,
sql_errm IN VARCHAR2,
pkg      IN VARCHAR2,
rtn      IN VARCHAR2);
TBD
 
ENSURE_NONNULL
Undocumented

Overload 1
dbms_streams_tbs_int.ensure_nonnull(
arameter_name   IN VARCHAR2,
parameter_value IN VARCHAR2,
routine_name    IN VARCHAR2);
TBD
Overload 2 dbms_streams_tbs_int.ensure_nonnull(
parameter_name  IN VARCHAR2,
parameter_value IN BOOLEAN,
routine_name    IN VARCHAR2);
TBD
 
GENERATE_FILE_NAME
Undocumented dbms_streams_tbs_int.generate_file_name(
path      IN VARCHAR2,
prefix    IN VARCHAR2,
extension IN VARCHAR2,
version   IN VARCHAR2,
is_asm    IN BOOLEAN)
RETURN VARCHAR2;
TBD
 
GET_FILE_COUNT
Undocumented dbms_streams_tbs_int.get_file_count(canon_tablespace_name IN VARCHAR2) RETURN NUMBER;
TBD
 
GET_FILE_GROUP_FILE_INFO
Undocumented dbms_streams_tbs_int.get_file_group_file_info(
trace_setting          IN  NUMBER,
canon_file_group_owner IN  VARCHAR2,
canon_file_group_name  IN  VARCHAR2,
version_id             IN  NUMBER,
file_id                IN  NUMBER,
file_name              OUT VARCHAR2,
canon_file_dir_obj     OUT VARCHAR2,
file_type              OUT VARCHAR2);
TBD
 
GET_FILE_GROUP_INFO
Undocumented dbms_streams_tbs_int.get_file_group_info(
trace_setting          IN  NUMBER,
canon_file_group_owner IN  VARCHAR2,
canon_file_group_name  IN  VARCHAR2,
canon_version_name     IN  VARCHAR2,
file_group_exists      OUT VARCHAR2,
version_exists         OUT VARCHAR2,
canon_directory_object OUT VARCHAR2);
TBD
 
GET_FILE_GROUP_VERSION_INFO
Undocumented dbms_streams_tbs_int.get_file_group_version_info(
trace_setting          IN  NUMBER,
canon_file_group_owner IN  VARCHAR2,
canon_file_group_name  IN  VARCHAR2,
canon_version_name     IN  VARCHAR2,
version_id             OUT NUMBER,
file_count             OUT NUMBER,
export_platform        OUT VARCHAR2);
TBD
 
GET_LOCAL_PLATFORM
Undocumented dbms_streams_tbs_int.get_local_platform RETURN VARCHAR2;
SELECT dbms_streams_tbs_int.get_local_platform
FROM dual;
SELECT dbms_streams_tbs_int.get_local_platform FROM dual
       *
ERROR at line 1:
ORA-06553: PLS-904: insufficient privilege to access object DBMS_STREAMS_TBS_INT
 
GET_LOCAL_PLATFORM_ID
Undocumented dbms_streams_tbs_int.get_local_platform_id RETURN BINARY_INTEGER;
SELECT dbms_streams_tbs_int.get_local_platform_id AS PLATFORM_ID
FROM dual;
SELECT dbms_streams_tbs_int.get_local_platform_id AS PLATFORM_ID
*
ERROR at line 1:
ORA-06553: PLS-904: insufficient privilege to access object DBMS_STREAMS_TBS_INT
 
GET_TABLESPACE_INFORMATION
Undocumented dbms_streams_tbs_int.get_tablespace_information(canon_tablespace_name IN VARCHAR2)
RETURN sys.dbms_streams_tbs_int.tbs_filename_fileid_type;
TBD
 
PARSE_FILE_NAME
Undocumented dbms_streams_tbs_int.parse_file_name(
file_name IN  VARCHAR2,
is_asm    IN  BOOLEAN,
path      OUT VARCHAR2,
prefix    OUT VARCHAR2,
extension OUT VARCHAR2,
version   OUT VARCHAR2);
DECLARE
 filenIn dbms_id := '/u01/app/oracle/orabase/oradata/isbdtbs.dbf';
 pathOut dbms_id;
 prefOut dbms_id;
 extnOut dbms_id;
 versOut dbms_id;
BEGIN
  dbms_streams_tbs_int.parse_file_name(filenIn, FALSE, pathOut, prefOut, extnOut, versOut);
  dbms_output.put_line(pathOut);
  dbms_output.put_line(prefOut);
  dbms_output.put_line(extnOut);
  dbms_output.put_line(versOut);
END;
/
 dbms_streams_tbs_int.parse_file_name(filenIn, FALSE, pathOut, prefOut, extnOut, versOut);
*
ERROR at line 8:
ORA-06550: line 8, column 3:
PLS-00904: insufficient privilege to access object DBMS_STREAMS_TBS_INT
ORA-06550: line 8, column 3:
PL/SQL: Statement ignored
 
RAISE_INVALID
Undocumented dbms_streams_tbs_int.raise_invalid(
parameter_name  IN VARCHAR2,
parameter_value IN VARCHAR2,
routine_name    IN VARCHAR2,
keeperrorstack  IN BOOLEAN);
TBD
 
REMOVE_FILE
Undocumented dbms_streams_tbs_int.remove_file(
fq_file_name IN VARCHAR2,
file_type    IN VARCHAR2);
TBD
 
TRACE_COMMON
Undocumented dbms_streams_tbs_int.trace_common(
rtn                   IN VARCHAR2,
canon_tablespace_name IN VARCHAR2,
exception_handler     IN BOOLEAN);
TBD
 
TRACE_CONVERT_FILE
Undocumented dbms_streams_tbs_int.trace_convert_file(
input_filename     IN VARCHAR2,
input_filenumber   IN BINARY_INTEGER,
input_platform_id  IN BINARY_INTEGER,
output_filename    IN VARCHAR2,
output_platform_id IN BINARY_INTEGER,
convert_at_source  IN BOOLEAN,
exception_handler  IN BOOLEAN);
TBD
 
TRACE_ENTRY
Undocumented dbms_streams_tbs_int.trace_entry(
routine_name IN VARCHAR2,
force        IN BOOLEAN);
TBD
 
TRACE_EXPRESSION
Undocumented

Overload 1
dbms_streams_tbs_int.trace_expression(
expression_name  IN VARCHAR2,
expression_value IN VARCHAR2,
force            IN BOOLEAN);
TBD
Overload 2 dbms_streams_tbs_int.trace_expression(
expression_name  IN VARCHAR2,
expression_value IN BOOLEAN,
force            IN BOOLEAN);
TBD
 
TRACE_INVOCATION
Undocumented dbms_streams_tbs_int.trace_invocation(
routine_name IN VARCHAR2,
force        IN BOOLEAN);
TBD

Related Topics
Built-in Functions
Built-in Packages
Database Security
DBMS_STREAMS
DBMS_STREAMS_TBS_INT_INVOK
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-2021 Daniel A. Morgan All Rights Reserved
  DBSecWorx