Results 1 to 3 of 3
  1. #1
    dav007 is offline Member
    Join Date
    Feb 2011
    Posts
    2
    Rep Power
    0

    Unhappy Error creating a new database in Oracle 10g

    I am getting an error when I try to create a fresh database using "create database command".

    I am getting database already mounted error.

    Any ideas, what should I do?

  2. #2
    travishein's Avatar
    travishein is offline Senior Member
    Join Date
    Sep 2009
    Location
    Canada
    Posts
    684
    Rep Power
    5

    Default

    probably your oracle database user does not have the correct privileges for creating a database.
    most DBA will create a user account to access the schema, such as the application, separate from the administrative user that is required for creating databases.

    In some cases the application's user account is even restricted from creating or dropping tables.

    Maybe contact your DBA and have them create the database for you, or have them grant you the create database privilege

  3. #3
    Tolls is offline Moderator
    Join Date
    Apr 2009
    Posts
    12,014
    Rep Power
    20

    Default

    Are you actually trying to create a databse?
    Follow the steps here.

    Second, this is a Java forum and this question is an Oracle question, so you might want to take it to OTN (the Oracle forums).

    Finally, are you sure you're creating a database? And you don't simply want to create a new schema?

Similar Threads

  1. inserting date in oracle database
    By jackjosh_in in forum Advanced Java
    Replies: 6
    Last Post: 05-23-2010, 06:38 PM
  2. Replies: 4
    Last Post: 12-19-2009, 10:16 AM
  3. Error euro sign on oracle database
    By ct2marer in forum JDBC
    Replies: 0
    Last Post: 10-26-2009, 12:07 PM
  4. how to display data from oracle database?
    By deru4jesus in forum JavaServer Faces (JSF)
    Replies: 0
    Last Post: 04-16-2009, 08:46 AM
  5. Probeleme with insert into database oracle
    By bachtoutou in forum New To Java
    Replies: 0
    Last Post: 05-24-2008, 11:56 AM

Posting Permissions

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