RE: Creating new user

From: Mark Leith <mark_at_cool-tools.co.uk>
Date: Tue, 22 Oct 2002 04:19:07 -0800
Message-ID: <F001.004EF8FA.20021022041907@fatcity.com>

Santosh,

Time to break out the documentation (a.k.a RTFM).

"create user <username> identified by <password> default tablespace <ts_name> temporary tablespace <temp_ts> quota <whatever> on <ts_name>". You will also need to grant some resources to this user. First things first "CONNECT" would be a good idea..

Then break out the docs on "Import". Or read the web site as listed in every email message to this list:

http://www.orafaq.com/faqiexp.htm

If you have any more specific questions, fire away :)

HTH Mark
Cool-Tools UK Limited

 -----Original Message-----
Varma

Sent:	22 October 2002 12:44
To:	Multiple recipients of list ORACLE-L
Subject:	Creating new user

how to create a new user ? in oracle 8.1.7 ? and i want to import a dump file into that user so that i could create the tables. How to acheive this ?  

any help will be appreciated.

Thanks and regards,

Santosh  

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Mark Leith
  INET: mark_at_cool-tools.co.uk

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 Tue Oct 22 2002 - 07:19:07 CDT