Creates a dictionary directory in the Oracle CDD/Repository data
dictionary system.
Format
DEFINE DICTIONARY path-name
1 – Argument
path-name
Is the given name, the full dictionary path name, or a relative
dictionary path name of the dictionary you want to create. The
DEFINE DICTIONARY command accepts both DMU and CDO style path
names. A complete CDO style path name has the following format:
node-spec::device:[directory]file-name.type;version
2 – Examples
Use a given name to define a dictionary directory named TEST when
CDD$TOP.RESEARCH is your default directory:
DTR> SHOW DICTIONARY
The default directory is CDD$TOP.RESEARCH
DTR> DEFINE DICTIONARY TEST
DTR> SHOW DICTIONARIES
Dictionaries:
DEMO TEST
DTR> SET DICTIONARY TEST
DTR> SHOW DICTIONARY
The default dictionary is CDD$TOP.RESEARCH.TEST
DTR> SHOW PRIVILEGES
Privileges for CDD$TOP.RESEARCH.TEST
R (DTR_READ) - may ready for READ, use SHOW and EXTRACT
W (DTR_WRITE) - may ready for READ, WRITE, MODIFY, or EXTEND
M (DTR_MODIFY) - may ready for READ, MODIFY
E (DTR_EXTEND/EXECUTE) - may ready to EXTEND, or access table or procedure
C (CONTROL) - may issue DEFINEP, SHOWP, DELETEP commands
D (LOCAL_DELETE) - may delete a dictionary object
F (FORWARD) - may create a subdictionary
H (HISTORY) - may add entries to object's history list
P (PASS_THRU) - may use given name of directory or object in pathname
S (SEE) - may see (read) dictionary
U (UPDATE) - may update dictionary object
X (extend) - may create directory or object within directory
DTR>
Use a relative dictionary path name to define a dictionary
directory in the CDD$TOP.MANUFACTURING directory when
CDD$TOP.DTR$LIB is your default directory:
DTR> SHOW DICTIONARY
The default directory is CDD$TOP.DTR$LIB
DTR> DEFINE DICTIONARY
DFN> -.MANUFACTURING.TEST
DTR> SET DICTIONARY -.MANUFACTURING
DTR> SHOW DICTIONARIES
INVENTORY TEST
DTR> SHOWP TEST
1: [*,*], Username: "JONES"
Grant - CDHPSX, Deny - None, Banish - none
DTR>
Use a full name to define a CDO dictionary directory named TEST.
DISK1:[SWANSON.DTRWORK] is your default directory:
DTR> SHOW DICTIONARY
The default directory is DISK1:[SWANSON.DTRWORK]
DTR> DEFINE DICTIONARY DISK1:[SWANSON.DTRWORK]TEST
DTR> SHOW DICTIONARIES
Dictionaries:
MYDICT TEST
DTR>