Oracle | DBMS_STREAMS_TBS

Oracle DBMS_STREAMS_TBS_INT Version 21c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

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.

Direct access to some objects in this package is prevented by means of an Accessible By clause.

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

Subprograms

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

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