Which has the higher priority in your organization: Deploying a new database or securing the ones you already have?
Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.
Purpose
Creates a table used for identifying chained rows in index organized tables. This package is not created by the DBCA installation because it is not required with
database versions greater than 8.0.
I am documenting it here in the library because, for reasons beyond my comprehension, Oracle won't drop it from the distribution. If they keep it ... The Library keeps it.
SP2-0808: Package created with compilation warnings
Synonym created.
Grant succeeded.
Library created.
SP2-0810: Package Body created with compilation warnings
SQL> sho err
Errors for PACKAGE BODY DBMS_IOT:
LINE/COL ERROR
-------- -----------------------------------------------------------------
92/21 PLW-07203: parameter 'C_NAM' may benefit from use of the NOCOPY
compiler hint
518/3 PLW-06002: Unreachable code
dbms_iot.check_redundant_pkey(
table_owner IN VARCHAR2,
table_name IN VARCHAR2,
index_owner IN VARCHAR2,
index_name IN VARCHAR2,
uniqueness IN VARCHAR2,
nblk_uniq IN BINARY_INTEGER DEFAULT NULL)
RETURN VARCHAR2;