DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Reserved Names for Oracle Database

  1. 05-14-2003, 11:34 AM #1
    gaegoori
    gaegoori is offline Member
    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
    Reply With Quote Reply With Quote
  2. 05-14-2003, 11:46 AM #2
    patel_dil
    patel_dil is offline Senior Member
    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
    Reply With Quote Reply With Quote
  3. 05-14-2003, 11:59 AM #3
    marcio.68
    marcio.68 is offline Carpe.Diem
    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
    Reply With Quote Reply With Quote
  4. 05-15-2003, 03:38 AM #4
    Tarry's Avatar
    Tarry
    Tarry is offline Senior Advisor
    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---
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width