1) select * from v$database; Note: Picky perhaps, but "instance" and "database" may be different. ... 3) grant create session to scott; Note: CONNECT is a role that includes the create session system privilege and a LOT more. It is NOT a synonym for "create session". ... Don Granaman OraSaurus
----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Saturday, February 08, 2003 11:33 PM > 1)How to find out from sqlplus what is the current > database ? > > once, connected, do "select * from v$instance;" > > 2)and how to switch to another one ? > > from DOS prompt: by chaning your ORACLE_SID environment variable > or via Net8: either from SQL*Plus: connect system/manager@another_db > or from DOS: sqlplus system/manager@another_db. > > 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 ? > > create user scott identified by tiger default tablespace users temporary > tablespace temp; > > grant connect to scott; > > 4)Do I need to create a tablespace for my new > database, if so how to do it ? > > OK, now I am gonna suggest you to read the Oracle's documentation: > especially the "Administrator's Guide". It's availabe on otn.oracle.com. > > 5)How to create tables ? > > See answer for #4. > > 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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: Richard Ji > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: Don Granaman INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).