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 will be available on generic Linux platforms in January and soon on AIX and Windows

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