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>