nixCraft

Excuse me, I had installed oracle in my PC for doing assignment, but I am a new user of oracle. I have some problems when trying oracle.

The first one is, how to create database in oracle? Actually I know the statement is "CREATE DATABASE xxx", but I don't know why I can't create it, the database said I don't have enough authority. When installing Oracle, two a/c passwords must be satisfied, sys and system. But when I want to use sys a/c to login, I don't know why the password is wrong, so I use system a/c to login, but it say not enough authority to create database, what can I do for this situation?

The second one is, how to use various databases using sql commands in oracle.., as we can do in mysql(use database <database_name>)

Thank you for those members.

Oracle uses different commands to create database. You need to set SID. Are you on Windows or UNIX host? Have you tried out GUI and Webbased tools?

__________________
Vivek Gite
Linux Evangelist
Be proud RHEL user, and let the world know about your enterprise choices! Join RedHat user group.
Always use CODE tags for posting system output and commands!
Do you run a Linux? Let's face it, you need help

i work on windows ...
wud u direct me how to use the above mentioned tools......
thanking you

Open browser and type http://127.0.0.1:8080/apex

Login as system and create database, users and other stuff.

There should be a GUI tool install under Oracle - On Windows Server or XP, from the Start menu, select Programs (or All Programs) and then Oracle Database 10g Express Edition.

but i hav got oracle 9i, ......
and the link is also not working

You can create an Oracle Database in three ways:

• Use the Database Configuration Assistant (DBCA).
  DBCA can be launched by the Oracle Universal Installer, depending upon the type of install that you select, and provides a graphical user interface (GUI) that guides you through the creation of a database. You can also launch DBCA as a standalone tool at any time after Oracle Database installation to create or make a copy (clone) of a database. Refer to Oracle Database 2 Day DBA for detailed information on creating a database using DBCA.
• Use the CREATE DATABASE statement.
  You can use the CREATE DATABASE SQL statement to create a database. If you do so, you must complete additional actions before you have an operational database. These actions include creating users and temporary tablespaces, building views of the data dictionary tables, and installing Oracle built-in packages. These actions can be performed by executing prepared scripts, many of which are supplied for you.
  If you have existing scripts for creating your database, consider editing those scripts to take advantage of new Oracle Database features. Oracle provides a sample database creation script and a sample initialization parameter file with the Oracle Database software files. Both the script and the file can be edited to suit your needs. See "Manually Creating an Oracle Database".
• Upgrade an existing database.
  If you are already using a earlier release of Oracle Database, database creation is required only if you want an entirely new database. You can upgrade your existing Oracle Database and use it with the new release of the database software. The Oracle Database Upgrade Guide manual contains information about upgrading an existing Oracle Database.

The remainder of this chapter discusses creating a database manually.