DTRHELP.HLB  —  Commands Statements Clauses, DEFINE DICTIONARY Command
       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>
Close Help