Oracle-L: Re: newbie question

From: <Reginald.W.Bailey_at_jpmorgan.com>
Date: Sat, 08 Feb 2003 19:18:37 -0800
Message-ID: <F001.00547F41.20030208191837@fatcity.com>

Majid:

Try "select name from v$database;"
Use the "connect" keyword to connect to another database. Example : connect userid_at_database_name.
To create users, try "create user [username] identified by [password] default tablespace [tablespace_name] temporary tablespace [tablespace_name] ; grant create session to [username];" That is the minimum needed to create a user.

For further instructions I suggest you try reading the Oracle documentation. From your questions I believe you need to become a little more familiar with Oracle.
There is a difference between questions that are typical for a "newbie" and those that signify "I haven't got a clue". To answer the rest of your questions
and to become more familiar with Oracle usage, try technet.oracle.com.

Good hunting!

RWB majid <majidnakit_at_yahoo.com>@fatcity.com on 02/08/2003 08:28:35 PM

Please respond to ORACLE-L_at_fatcity.com

Sent by: root_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc:

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: majid
  INET: majidnakit_at_yahoo.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).




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: Reginald.W.Bailey_at_jpmorgan.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 Sat Feb 08 2003 - 21:18:37 CST