Database Reference
In-Depth Information
Parameters
Parameter
Description
name
Name of a database object in the format [
schema
.]
identifier1
[
.identifier2
]
[
@
database_link
], where all placeholders are valid SQL identifiers. All
components except
identifier1
are optional.
context
The context in which to resolve a name. An integer between 1 and 7 (not 0
and 8 as stated in the documentation).
1
Names of different object types
must be resolved in the correct context. See Table 21-1 for the mapping
from object type to
context
.
schema
Schema containing the resolved object.
part1
Database object name.
part2
Lower level database object name, such as a column of a table or procedure
in a package. No check for correctness is performed at this level.
dblink
Database link name, if present in parameter
name
.
part1_type
Numeric code representing the object type of
part1
. See Table 21-2 for
mapping type codes to object types.
object_number
The unique numeric object identification from
DBA_OBJECTS.OBJECT_ID
. If
name
contains a database link, then
object_number
is zero.
If the type of an object is unknown, all contexts must be tried in an attempt to resolve a
name. Table 21-1 lists the supported object types and the corresponding context numbers.
Clusters, database links (by themselves), directories, indexes, LOB column names, queues, rule
names, and rule sets cannot be resolved. Use the packaged procedure
DBMS_UTILITY.NAME_
TOKENIZE
to decompose names of such objects for easier lookup in the data dictionary.
1
1.Values outside of the range 1-7 cause “ORA-20005: ORU-10034: context argument must be 1 or 2 or 3 or
4 or 5 or 6 or 7”.