Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: newbie question
I would strongly recommend a good beginner DBA text such as DBA 101.
http://www.amazon.com/exec/obidos/tg/detail/-/0072224746/qid=1044859784
This will give you a good foundation for reading the docs.
Jared
On Saturday 08 February 2003 18:28, majid wrote:
> Hi,
> I used to use mysql databse, now I am new to Oracle, I
> just created a database called "majidDB" in Oracle8i
> using Database Configuration Assistant, a directory
> is created automatically after creation of the
> database : D:\Oracle\ORADATA\majidDB
>
> 1)How to find out from sqlplus what is the current
> database ?
> 2)and how to switch to another one ?
> 3)How to create users in my new database ? after
> creating users do I have to do something to allow them
> get connected from another machine ?
> 4)Do I need to create a tablespace for my new
> database, if so how to do it ?
> 5)How to create tables ?
>
> Thank you your help is appreciated.
>
>
> __________________________________________________
> Do you Yahoo!?
> Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
> http://mailplus.yahoo.com
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: jkstill_at_cybcon.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Mon Feb 10 2003 - 00:53:36 CST