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
Undocumented
AUTHID
DEFINER
Dependencies
DBMS_HS
HS$_CLASS_CAPS
HS$_FDS_INST
DBMS_HS_ALT
HS$_CLASS_DD
HS$_INST_CAPS
DBMS_HS_UTL
HS$_CLASS_INIT
HS$_INST_DD
HS$_BASE_CAPS
HS$_FDS_CLASS
HS$_INST_INIT
HS$_BASE_DD
Documented
No
Exceptions
Error Code
Reason
ORA-24274
no row exists in the HS$_BASE_DD table for these parameters
Checks to determine whether a table is listed in HS$_BASE_DD
dbms_hs_chk.check_base_dd(dd_table_name IN VARCHAR2) RETURN NUMBER;
SELECT dbms_hs_chk.check_base_dd('TAB$')
FROM dual;
SELECT dbms_hs_chk.check_base_dd('TAB$')
*
ERROR at line 1:
ORA-24274: no row exists in the HS$_BASE_DD table for these parameters
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.DBMS_HS_UTL", line 431
ORA-06512: at "SYS.DBMS_HS_CHK", line 66
desc HS$_BASE_DD Name Null? Type
------------------- -------- -------------
DD_TABLE_ID NOT NULL NUMBER
DD_TABLE_NAME NOT NULL VARCHAR2(128)
DD_TABLE_DESC VARCHAR2(255)