Create database in Oracle
Posted on 2012-04-03
I wanted to create a new database in Oracle but I seem to be making a mess of it and not sure how to correct.
I did the following in the command prompt...
Enter user-name: system
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> create user myDatabase identified by myDatabase
SQL> grant connect,resource,dba to myDatabase
Then, I tried to log on via TOAD using myDatabase as username and password...
Actually, now that I look at TOAD, I have another database called RT on the server, and the database seems to be called ORCL while the user / Schema seems to be RT. So, what did I do above... I created another database beside ORCL, when what I really want to do is create another schema? Or do I want to create two totally separate databases?