I am using Oracle 11g and there is a database create during installation name "xyz" and user "xyz".Now i created a user 'abc' and gave following permission to abc.
"CREATE SESSION, ALTER SESSION, CREATE DATABASE LINK, CREATE MATERIALIZED VIEW, CREATE PROCEDURE, CREATE PUBLIC SYNONYM, CREATE ROLE, CREATE SEQUENCE, CREATE SYNONYM, CREATE TABLE, CREATE TRIGGER, CREATE TYPE, CREATE VIEW, UNLIMITED TABLESPACE"
Now, I am trying to create database named 'abc'
At the time of creation of the database, I am get the following exception:
ORA-01501:CREATE DATABASE FAILED ORA-01100:DATABASE ALREADY MOUNTED
Please tell me how to come out of this. What standard procedure to be for creating database?