Re: Newbie - General Questions

On Wed, 5 Jun 2002, bbitzer_at_tripower.net wrote:
> 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.

Read this. You will need to get a technet id, but its free. http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a76965/toc.htm

Then, learn about administration by reading: http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a76956/toc.htm

Then, make sure you have the following url available at all times and use it as much as you should use google: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage

Then, make sure you search and use google extensively: http://groups.google.com/groups?hl=en&lr=&safe=off&group=comp.databases.oracle.server

And, one of the favorites of this group: http://asktom.oracle.com/pls/ask/f?p=4950:7:897988::NO:::

And an FAQ of answers by this group:
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

That should be enough to keep you busy for the rest of the year.

-- 
Galen Boyer