Oracle DBMS_STREAMS_TBS_INT_INVOK
Version 26ai

zzz
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 CURRENT_USER
Dependencies
ALL_DIRECTORIES DBMS_STREAMS_MT DBMS_UTILITY
DBA_DATA_FILES DBMS_STREAMS_RPC KU$_JOBSTATUS
DBA_TABLESPACES DBMS_STREAMS_TABLESPACE_ADM KU$_LOGENTRY
DBMS_DATAPUMP DBMS_STREAMS_TBS_INT KU$_LOGLINE1010
DBMS_LOCK DBMS_STREAMS_TBS_LIB KU$_STATUS
DBMS_LOGREP_UTIL DBMS_SYSTEM PLITBLM
DBMS_SQL DBMS_SYS_ERROR USER_TABLESPACES
DBMS_STANDARD    
Documented No
Exceptions
Error Code Reason
ORA-23609 unable to find directory object for directory <string>
First Available Not known
Security Model Owned by SYS with no privileges granted
Source {ORACLE_HOME}/rdbms/admin/prvthsts.plb
{ORACLE_HOME}/rdbms/admin/prvtbsts.plb
Subprograms
CHECK_PRIVILEGE IS_TABLESPACE_READWRITE PULL_TABLESPACE_INFO
DQ MAKE_TABLESPACE_READONLY PULL_TBS_FILE_NAME_ID
GET_DATA_FILE MAKE_TABLESPACE_READWRITE RPC_PULL_TABLESPACE_FILE_INFO
GET_SINGLE_DATA_FILE PARSE RPC_PULL_TABLESPACE_INFO
GET_SINGLE_FILE PRINT_ANY_ERROR RPC_PULL_TBS_FILE_NAME_ID
GET_TABLESPACE_FILES PULL_ALTER_TABLESPACE TABLESPACES_EXIST_NUM
GET_TABLESPACE_STATUS PULL_PLATFORM WAIT_FOR_TERMINATION
IS_TABLESPACE_READONLY PULL_TABLESPACE_FILE_INFO  
 
CHECK_PRIVILEGE
Undocumented

Overload 1		 dbms_streams_tbs_int_invok.check_privilege(
canon_directory_object IN VARCHAR2,
operation              IN VARCHAR2);
TBD
Overload 2 dbms_streams_tbs_int_invok.check_privilege(
canon_directory_object IN VARCHAR2,
operation              IN VARCHAR2)
RETURN BOOLEAN;
TBD
 
DQ
Undocumented dbms_streams_tbs_int_invok.dq(token IN VARCHAR2) RETURN VARCHAR2;
TBD
 
GET_DATA_FILE
Undocumented dbms_streams_tbs_int_invok.get_data_file(
canon_tablespace_name  IN  VARCHAR2,
file_number            IN  NUMBER,
canon_directory_object OUT VARCHAR2,
file_name              OUT VARCHAR2,
file_id                OUT NUMBER);
TBD
 
GET_SINGLE_DATA_FILE
Undocumented but clearly it is having a bit of an issue with ASM

We cannot think of any reason why this does not qualify as a bug. Surely a more graceful exit could be implemented.		 dbms_streams_tbs_int_invok.get_single_data_file(canon_tablespace_name IN VARCHAR2)
RETURN VARCHAR2;
SELECT dbms_streams_tbs_int_invok.get_single_data_file('USERS');
       *
ORA-23609: unable to find directory object for directory +DATA/TEST21DB_IAD25G/DATAFILE/
 
GET_SINGLE_FILE
Undocumented dbms_streams_tbs_int_invok.get_single_file(
canon_tablespace_name  IN  VARCHAR2,
canon_directory_object OUT VARCHAR2,
file_name              OUT VARCHAR2);
TBD
 
GET_TABLESPACE_FILES
Undocumented dbms_streams_tbs_int_invok.get_tablespace_files(
canon_tablespace_names IN sys.dbms_streams_tablespace_adm.tablespace_set,
canon_database_link    IN VARCHAR2)
RETURN sys.dbms_streams_tablespace_adm.file_set;
TBD
 
GET_TABLESPACE_STATUS
Undocumented dbms_streams_tbs_int_invok.get_tablespace_status(canon_tablespace_name IN VARCHAR2)
RETURN VARCHAR2;
TBD
 
IS_TABLESPACE_READONLY
Undocumented dbms_streams_tbs_int_invok.is_tablespace_readonly(canon_tablespace_name IN VARCHAR2)
RETURN BOOLEAN;
BEGIN
  IF dbms_streams_tbs_int_invok.is_tablespace_readonly('UWDATA') THEN
    dbms_output.put_line('T');
  ELSE
    dbms_output.put_line('F');
  END IF;
END;
/
F

PL/SQL procedure successfully completed.
 
IS_TABLESPACE_READWRITE
Undocumented dbms_streams_tbs_int_invok.is_tablespace_readwrite(canon_tablespace_name IN VARCHAR2)
RETURN BOOLEAN;
BEGIN
  IF dbms_streams_tbs_int_invok.is_tablespace_readwrite('UWDATA') THEN
    dbms_output.put_line('T');
  ELSE
    dbms_output.put_line('F');
  END IF;
END;
/
T

PL/SQL procedure successfully completed.
 
MAKE_TABLESPACE_READONLY
Undocumented dbms_streams_tbs_int_invok.make_tablespace_readonly(canon_tablespace_name IN VARCHAR2);
SELECT tablespace_name, status
FROM dba_tablespaces
ORDER BY 1;

TABLESPACE_NAME                STATUS
------------------------------ ---------
AUDIT_TBSP                     ONLINE
CDBROOT_TEMP                   ONLINE
ISBD_TBS                       ONLINE
SYSAUX                         ONLINE
SYSTEM                         ONLINE
TEMP                           ONLINE
UNDOTBS1                       ONLINE
USERS                          ONLINE
UWDATA READ                    ONLINE

exec dbms_streams_tbs_int_invok.make_tablespace_readonly('UWDATA');

PL/SQL procedure successfully completed.

SELECT tablespace_name, status
FROM dba_tablespaces
ORDER BY 1;

TABLESPACE_NAME                STATUS
------------------------------ ---------
AUDIT_TBSP                     ONLINE
CDBROOT_TEMP                   ONLINE
ISBD_TBS                       ONLINE
SYSAUX                         ONLINE
SYSTEM                         ONLINE
TEMP                           ONLINE
UNDOTBS1                       ONLINE
USERS                          ONLINE
UWDATA                         READ ONLY
 
MAKE_TABLESPACE_READWRITE
Undocumented dbms_streams_tbs_int_invok.make_tablespace_readwrite(canon_tablespace_name IN VARCHAR2);
SELECT tablespace_name, status
FROM dba_tablespaces
ORDER BY 1;

TABLESPACE_NAME                STATUS
------------------------------ ---------
AUDIT_TBSP                     ONLINE
CDBROOT_TEMP                   ONLINE
ISBD_TBS                       ONLINE
SYSAUX                         ONLINE
SYSTEM                         ONLINE
TEMP                           ONLINE
UNDOTBS1                       ONLINE
USERS                          ONLINE
UWDATA                         READ ONLY
exec dbms_streams_tbs_int_invok.make_tablespace_readwrite('UWDATA');

PL/SQL procedure successfully completed.

SELECT tablespace_name, status
FROM dba_tablespaces
ORDER BY 1;

TABLESPACE_NAME                STATUS
------------------------------ ---------
AUDIT_TBSP                     ONLINE
CDBROOT_TEMP                   ONLINE
ISBD_TBS                       ONLINE
SYSAUX                         ONLINE
SYSTEM                         ONLINE
TEMP                           ONLINE
UNDOTBS1                       ONLINE
USERS                          ONLINE
UWDATA READ                    ONLINE
 
PARSE
Undocumented dbms_streams_tbs_int_invok.parse(
file_string            IN  VARCHAR2,
is_asm                 IN  BOOLEAN,
canon_directory_object OUT VARCHAR2,
file_name              OUT VARCHAR2);
TBD
 
PRINT_ANY_ERROR
Undocumented dbms_streams_tbs_int_invok.print_any_error(
status          IN public.ku$_status,
raise_exception IN BOOLEAN);
desc ku$_status

Name             Null? Type
---------------- ----- -----------------
MASK                   NUMBER
WIP                    KU$_LOGENTRY1010
JOB_DESCRIPTION        KU$_JOBDESC1220
JOB_STATUS             KU$_JOBSTATUS1220
ERROR                  KU$_LOGENTRY1010
 
PULL_ALTER_TABLESPACE
Undocumented dbms_streams_tbs_int_invok.pull_alter_tablespace(
trace_setting   IN NUMBER,
tablespace_name IN VARCHAR2,
alter_option    IN VARCHAR2);
TBD
 
PULL_PLATFORM
Undocumented dbms_streams_tbs_int_invok.pull_platform(
trace_setting IN  NUMBER,
platform      OUT VARCHAR2);
TBD
 
PULL_TABLESPACE_FILE_INFO
Undocumented dbms_streams_tbs_int_invok.pull_tablespace_file_info(
trace_setting          IN  NUMBER,
tablespace_name        IN  VARCHAR2,
file_number            IN  NUMBER,
canon_directory_object OUT VARCHAR2,
file_name              OUT VARCHAR2);
TBD
 
PULL_TABLESPACE_INFO
Undocumented dbms_streams_tbs_int_invok.pull_tablespace_info(
trace_setting   IN  NUMBER,
tablespace_name IN  VARCHAR2,
file_count      OUT NUMBER,
alter_needed    OUT VARCHAR2);
TBD
 
PULL_TBS_FILE_NAME_ID
Undocumented dbms_streams_tbs_int_invok.pull_tbs_file_name_id(
trace_setting          IN  NUMBER,
tablespace_name        IN  VARCHAR2,
file_number            IN  NUMBER,
canon_directory_object OUT VARCHAR2,
file_name              OUT VARCHAR2,
file_id                OUT NUMBER);
TBD
 
RPC_PULL_TABLESPACE_FILE_INFO
Undocumented dbms_streams_tbs_int_invok.rpc_pull_tablespace_file_info(
database_link          IN  VARCHAR2,
tablespace_name        IN  VARCHAR2,
file_number            IN  NUMBER,
canon_directory_object OUT VARCHAR2,
file_name              OUT VARCHAR2);
TBD
 
RPC_PULL_TABLESPACE_INFO
Undocumented dbms_streams_tbs_int_invok.rpc_pull_tablespace_info(
database_link   IN  VARCHAR2,
tablespace_name IN  VARCHAR2,
file_count      OUT NUMBER,
alter_needed    OUT BOOLEAN);
TBD
 
RPC_PULL_TBS_FILE_NAME_ID
Undocumented dbms_streams_tbs_int_invok.rpc_pull_tabs_file_name_id(
database_link          IN  VARCHAR2,
tablespace_name        IN  VARCHAR2,
file_number            IN  NUMBER,
canon_directory_object OUT VARCHAR2,
file_name              OUT VARCHAR2,
file_id                OUT NUMBER);
TBD
 
TABLESPACES_EXIST_NUM
Undocumented dbms_streams_tbs_int_invok.tablespaces_exist_num(
canon_tbs_names_str IN  VARCHAR2,
exist_num           OUT NUMBER);
DECLARE
 ctns   dbms_id := 'UWDATA';
 outVal NUMBER;
BEGIN
  dbms_streams_tbs_int_invok.tablespaces_exist_num(ctns, outVal);
  dbms_output.put_line(outVal);
END;
/
2

PL/SQL procedure successfully completed.
 
WAIT_FOR_TERMINATION
Undocumented dbms_streams_tbs_int_invok.wait_for_termination(
dp   IN NUMBER,
mask IN NUMBER);
TBD

Related Topics
Built-in Functions
Built-in Packages
Database Security
DBMS_STREAMS
DBMS_STREAMS_TBS_INT
What's New In 21c
What's New In 26ai

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