CONTENTS

  Title Page

  Copyright Page

  Send Us Your Comments

  Preface

  1      Fundamental Concepts
    1.1 Introduction to the Character-Cell Interface
      1.1.1      Invoking the Character-Cell Interface
      1.1.2      When to Use the Character-Cell Interface
      1.1.3      Understanding Access by Several Users
    1.2 Using Path Names
      1.2.1      Understanding Path Name Components
      1.2.2      Understanding the Path Name Hierarchy
      1.2.3      Specifying Path Names
      1.2.4      Path Name Syntax Rules
    1.3 Understanding Statement Syntax Rules
      1.3.1      Terminating Statements
      1.3.2      Understanding Case Sensitivity
      1.3.3      Using Quotation Marks
      1.3.4      Using Abbreviations
      1.3.5      Using Qualifiers and Options
    1.4 Creating and Using an Initialization File
      1.4.1      A Sample Initialization File
      1.4.2      Using an Initialization File
      1.4.3      How Oracle Expert for Rdb Searches for an Initialization File
    1.5 Sample Command Files
      1.5.1      Sample Physical Design Command Procedure
      1.5.2      Sample Tuning Command Procedure
    1.6 Statement Summary

  2      Character-Cell Interface Statements
    2.1 CLEAR Statement
    2.2 CLI Statement
    2.3 CLOSE REPOSITORY Statement
    2.4 COLLECT Statement
    2.5 COPY Statement
    2.6 CREATE Statement
    2.7 CREATE REPOSITORY Statement
    2.8 DEFINE/KEY Statement
    2.9 DELETE Statement
    2.10 DELETE REPOSITORY Statement
    2.11 DIRECTORY Statement
    2.12 ECHO Statement
    2.13 EDIT Statement
    2.14 Execute (@) Statement
    2.15 EXIT Statement
    2.16 EXPORT Statement, Design Element
    2.17 EXPORT Statement, Logical Schema
    2.18 EXPORT Statement, Physical Schema
    2.19 EXPORT Statement, Procedure
    2.20 EXPORT TUNE RECOMMENDATIONS Statement
    2.21 FORMAT Statement
    2.22 GENERATE PHYSICAL_SCHEMA Statement
    2.23 GENERATE TUNE RECOMMENDATIONS Statement
    2.24 GLOBAL DEFAULTS ARE Statement
    2.25 HELP Statement
    2.26 IMPORT ENVIRONMENT Statement
    2.27 IMPORT LOGICAL_SCHEMA Statement
    2.28 IMPORT TUNE ENVIRONMENT Statement
    2.29 IMPORT VOLUME Statement
    2.30 IMPORT WORKLOAD Statement
    2.31 MOVE Statement
    2.32 ON Statement
    2.33 OPEN REPOSITORY Statement
    2.34 PRINT Statement
    2.35 REPORT Statement
    2.36 RESERVE Statement
    2.37 SET Statement
    2.38 SHOW Statement
    2.39 SPAWN Statement
    2.40 TRANSPORT LOGICAL_SCHEMA Statement
    2.41 TRANSPORT WORKLOAD Statement
    2.42 UNRESERVE Statement
    2.43 VALIDATE Statement

  A DCL Command Summary
    A.1 RDBEXPERT Command

  B Deprecated Statements

  C Summary of Statements and DCL Commands Syntax
    C.1 Statements Syntax Summary
    C.2 DCL Command Syntax Summary