creating a database in sql

Replies

• 

  Vishal Sharma

  #-Link-Snipped-# Tagging the DB guy
• 

  Manish Goyal

  ask your db admin if you have rights to create new database
• 

  Aashish Joshi

  You may get this error if you're trying to create a new database when you have another one already mounted. The DB in use needs to be unmounted first before you can create a new DB.
  
  If you're using Oracle try the following steps and see if you're able to create a database:
  
  1. First log in using Sqlplus. Open command prompt or terminal and enter the following command:
  
  

  sqlplus /nolog
  

  2. Sign in as a user that has create database privilege. For example, if you have the sysdba privilege you an use this to sign in:
  

  connect username as sysdba
  

  3. If the database is already running then you'll need to shut it down first:
  

  shutdown normal
  

  4. Now start the database without mounting it:
  

  startup nomount
  

  Now you should be able to create a new database.
  
  Note: If you use Oracle's free eXpress Edition DB additional steps are required before you can create more than 1 database.