Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Database > BOOK: Beginning SQL
|
BOOK: Beginning SQL
This is the forum to discuss the Wrox book Beginning SQL by Paul Wilton, John Colby; ISBN: 9780764577321
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Beginning SQL section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old October 11th, 2007, 07:51 AM
dcr dcr is offline
Registered User
 
Join Date: Oct 2007
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default problem: Creating the Example Database

I installed Oracle SQL Developer and am using Oracle Database 10G Express Edition. Whenever I attempt to create the Film Club Database I get prompted with error message ORA 01100 - database already mounted. Do I need to create a new profile and then a new database? Since the only login I have created with a username and password seems to be

system:password

I have established a successful connection to Oracle 10G Express, so I'm really lost here and don't want to toss my laptop out my window just yet...
 
Old October 11th, 2007, 07:56 AM
dcr dcr is offline
Registered User
 
Join Date: Oct 2007
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Okay, I just solved my problem after spending half a day of cursing at my laptop. I needed to login and create a new user with privileges to create a new database, as the "system" profile already had one database associated with it. I suppose I could have kept exploring options to create a new database under that profile via the administration console, but I was unable to and just figured this out. I'm awesome.






Similar Threads
Thread Thread Starter Forum Replies Last Post
creating database application ruslaim VB Databases Basics 3 November 21st, 2007 10:25 PM
creating a database kcrist84 VB Databases Basics 3 July 20th, 2007 03:35 PM
Creating New Database everest SQL Server 2005 2 July 10th, 2007 01:32 PM
Problem creating drinks control database Odeh Naber Access VBA 5 August 5th, 2006 09:33 AM
problem creating database nusrati MySQL 15 July 6th, 2004 10:46 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.