You probably didn't need to create another database, just another schema.
You now have two instances.
Jim
"bbitzer" <bbitzer_at_tripower.net> wrote in message
news:1023279508.387757_at_news1.bigplanet.com...
> I works with and program in Access but want to learn Oracle. I am reading
a
> book on SQL*Plus and then one on PL/SQL to begin my self education. I
> installed the CD Pack of Oracle 8i Enterprise on my computer and had it
> create the default DB. Now I created another DB with a new name. It took a
> couple of hours while while the Database Configuration Assistant did most
> (all) of the work. I now have two DB's.One (the original) I log onto with
a
> username and password by the CREATE USER...
> DEFAULT TABLESPACE users
> TEMPORARY TABLESPACE Temp ....
>
> fine, the second DB is still System/Manager
>
> My questions are:
> 1. Do I need to create a different logon for each DB?
>
> 2. What is the Host (Connect) String and how do I apply one if needed?
>
> 3. How do I create different DB files (like in Acces ie. QTAX.mdb,
> TRS.mdb) without having to create an entire new Oracle Database (or am I
> understanding it wrong)?
>
> bottom line is that I want to understand how to create and/or manage
> different files, amd/or different databases.
> Any information, even if only to one questions is a geat help. Thank you.
>
>
Received on Wed Jun 05 2002 - 09:16:25 CDT
