SQL$HELP_OLD72.HLB  —  User Supplied Names, Database Names
    A database consists of physical data storage characteristics,
    such as a root file and storage area specifications; metadata
    definitions, such as tables and domains; and user data.

    By default, a database contains a single schema and no catalogs.
    If you specify the multischema attribute when creating your
    database, you can group the data definitions within one or more
    schemas within one or more catalogs. See the CREATE DATABASE for
    information on how to create a multischema database.

    When you create a database, you name it by specifying a file
    name and an optional repository path name in the CREATE DATABASE
    statement. You can supply a complete file specification, a
    partial file specification, or use system-supplied default
    values. You must use ASCII alphanumeric characters for the
    database name.

    To perform operations on a database, the database name is
    referenced through an attachment to that database called an
    alias. When you first refer to a database in SQL, you must
    indicate the source of data definitions for the database and the
    location of database files by declaring an alias. You can declare
    an alias using one of three statements:

    o  ATTACH

    o  CONNECT

    o  DECLARE ALIAS

    Choose a statement based on the interface that you are using
    (interactive SQL, SQL module language, or precompiled SQL) and
    your purpose (declaring a new alias or overriding the association
    between an alias and a database name). More information about
    aliases appears in Aliases.

    There are two ways to identify the source of data definitions:

    o  With a file specification

    o  With a repository path name (if the repository is installed on
       the system)
Additional Information: explode extract
Oracle Rdb Attach Specifications Repository Path Names
Close Help