Oracle | DBMS_STREAMS_TBS

Oracle DBMS_STREAMS_TBS_INT 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 Streams Tablespace Management Utilities

Streams was deprecated 03-Jan-2018 but this package still exists in 23ai but not installed by default

AUTHID DEFINER

Dependencies

ALL_DIRECTORIES	DBMS_STREAMS_DECL	DBMS_SYS_ERROR
DBA_DATA_FILES	DBMS_STREAMS_MT	DBMS_UTILITY
DBA_DIRECTORIES	DBMS_STREAMS_RPC	DUAL
DBMS_BACKUP_RESTORE	DBMS_STREAMS_TABLESPACE_ADM	FGR$_NAMES_S
DBMS_FILE_TRANSFER	DBMS_STREAMS_TBS_INT_INVOK	KU$_STATUS
DBMS_LOGREP_UTIL	DBMS_STREAMS_TBS_LIB	V$DATABASE
DBMS_STANDARD	DBMS_SYSTEM	V$TRANSPORTABLE_PLATFORM
DBMS_STREAMS_ADM_UTL

Data Types tbs_filename_fileid_type

Documented No

First Available Not known

Security Model Owned by SYS with no privileges granted.

Direct access to this package is prevented by an Accessible By clause.

Source {ORACLE_HOME}/rdbms/admin/prvthsts.plb
{ORACLE_HOME}/rdbms/admin/prvtbsts.plb

Subprograms

CANON	DEFAULT_FILE_NAME	GET_TABLESPACE_INFORMATION
CHECK_ASM	DETERMINE_CALL_TRACING	PARSE_FILE_NAME
CHECK_CDB	DUMP_ERROR	RAISE_INVALID
CHECK_FILE_EXISTS	ENSURE_NONNULL	REMOVE_FILE
COMBINE_DIR_AND_FILE	GENERATE_FILE_NAME	TRACE_COMMON
COMPARE_PATH_NAMES	GENERATE_NAME	TRACE_CONVERT_FILE
CONVERT_FILE	GET_FILE_COUNT	TRACE_ENTRY
CONVERT_FILE_AT_SOURCE	GET_LOCAL_PLATFORM	TRACE_EXPRESSION
CONVERT_PLATFORM_TO_ID	GET_LOCAL_PLATFORM_ID	TRACE_INVOCATION

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

GENERATE_NAME (new 23ai)

Undocumented dbms_streams_tbs_int.generate_name(seed_name IN VARCHAR2) RETURN VARCHAR2;

No demo possible

GET_FILE_COUNT

Undocumented dbms_streams_tbs_int.get_file_count(canon_tablespace_name IN VARCHAR2) RETURN NUMBER;

TBD

GET_LOCAL_PLATFORM

Undocumented dbms_streams_tbs_int.get_local_platform RETURN VARCHAR2;

No demo possible

GET_LOCAL_PLATFORM_ID

Undocumented dbms_streams_tbs_int.get_local_platform_id RETURN BINARY_INTEGER;

No demo possible

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);

No demo possible

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