Reserved Names for Oracle Database
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Reserved Names for Oracle Database

  1. #1
    Join Date
    Jun 2001
    Posts
    243

    Reserved Names for Oracle Database

    I was trying to install a database with global_name and SID to be equal to "backup" and keep getting error. ORA-00905 missing keyword. am I not allow to use "backup" as a database name?
    but my old database I have used db name as "backup" and I haven't run into this error. Any ideas?

    this is on Windows 2000 server and 9.2.0

  2. #2
    Join Date
    May 2001
    Location
    Maryland, USA
    Posts
    409
    Just tried creating a database in 817 with database name and sid as backup and it worked. Not sure about 9i2 version. Try creating database using DBCA and check it out.

    You may also want to look at
    http://download-west.oracle.com/docs...ywd.htm#617080

    For reserved words.

    I tried creating database using those words as SID and it gave me "ORA-02165:Invalid option for Create Database" Error. Again this is my observation for 8i.

    HTH
    Last edited by patel_dil; 05-14-2003 at 11:55 AM.
    -- Dilip

  3. #3
    Join Date
    Dec 2000
    Location
    Brazil / São Paulo
    Posts
    97
    It is not recommended to use words reserved for names of banks, tables, tablespaces, columns, etc. It can be that in previous versions you it has obtained, however does not make this in new versions, at least uses undescore "_".
    Márcio de Souza Almeida
    DBA Oracle / SQLServer / PostgreSQL
    Rua Cupa, 139 Apto 85 A
    Penha - São Paulo - SP
    03640-000 - Brasil
    http://www.directory.com.br

  4. #4
    Join Date
    Jan 2002
    Location
    Netherlands
    Posts
    1,587
    But as a general practice avoid using reserved names for db names, there are enough permutations&combinations to think of when naming your db.
    Tarry Singh
    I'm a JOLE(JavaOracleLinuxEnthusiast)
    TarryBlogging
    --- Everything was meant to be---

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width