RE: Creating new user

From: <Reginald.W.Bailey_at_jpmorgan.com>
Date: Tue, 22 Oct 2002 06:43:42 -0800
Message-ID: <F001.004EFC78.20021022064342@fatcity.com>

Santosh:

If the installation was to a PC, then check what type of installation was installed. If you used the Enterprise Edition Server CD then you should have chosen the "Custom" installation or "Client/DBA" installation option. The "Client/End User" option does not install Import and Export utilities. Do not select the "Client/Programmer" option either. The DBA option installs the DBA tools, and import is considered something for the DBA to use. As for how do you create a user, if you don't know, then I don't think it is a good idea to attempt to even do an import unitl you have become more familiar with Oracle DBA basics. Or you can use the Security Manager GUI installed with OEM. (That is an option also.)

RWB "Santosh Varma" <vsantosh_at_psi.soft.net>@fatcity.com on 10/22/2002 07:19:10 AM

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:

thanks ...but still

i gave imp command on command prompt..
but it tells imp not found...
and i checked the path also...i have given f:\oracle\bin as the path and there are no imp* files in oracle/bin.

any ideas ?
santosh

-----Original Message-----
hata
Sent: Tuesday, October 22, 2002 5:40 PM To: Multiple recipients of list ORACLE-L

SQL> CREATE USER <username> IDENTIFIED BY <password> [DEFAULT TABLESPACE <user_tablespace> TEMPORARY TABLESPACE <temp_tablespace>]

for importing on command prompt

imp username/password_at_database fromuser=<username> touser=<username> file=<export_dump_file>

If you just want the table structure and no data then use ROWS=N option too.

regards
Naveen
-----Original Message-----
Sent: Tuesday, October 22, 2002 5:14 PM To: Multiple recipients of list ORACLE-L

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:
  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 Tue Oct 22 2002 - 09:43:42 CDT