CODEWITHSUNDEEP
sqloracle-databaseoracle-sqldeveloper
cbilliau
cbilliau

Reputation: 1146

Unable to load example database from "SQL Queries For Mere Mortals" into Oracle's SQL Developer

I am trying to load in the example database for "sql queries for mere mortals" using the SQLScripts version of the example databases into Oracle SQL Developer but I keep getting this error:

Error at Command Line : 1 Column : 1

Error report -

SQL Error: ORA-01501: CREATE DATABASE failed

ORA-01100: database already mounted

  1. 00000 - "CREATE DATABASE failed"

*Cause: An error occurred during create database

*Action: See accompanying errors.

Is this a database error in my connection setup OR is there some SQL commands that need to be changed?

Upvotes: 0

Views: 1278

Answers (1)

Imre Kováts
Imre Kováts

Reputation: 26

You can download the fresh SQL scripts from their website (see the downloads link) http://www.informit.com/store/sql-queries-for-mere-mortals-a-hands-on-guide-to-data-9780321992475.

You need to run the scripts that create the schema for you first, and than you can run the files that insert data and stuff into them.

There is a mySQL folder in the archive that you are going to download.

The creation failure could also have happened because you've already imported a schema of the same name, but you forgot to refresh the schemas, so its "hidden" from plain view.

*Edit: Skipped over the Oracle part, here is a comparison table between mysql and oracle: https://docs.oracle.com/cd/E12151_01/doc.150/e12155/oracle_mysql_compared.htm#i1026408

Keep in mind though that mysql community is free; I think you should just download it and save the hassle, since you are using the software for learning purposes, you don't need to use any particular vendor's solution, like you normally would need to in a set production environment!

Upvotes: 1

Related Questions