-
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
-
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
-
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
-
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)
--- 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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|