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" <[EMAIL PROTECTED]>@fatcity.com on 10/22/2002 07:19:10 AM Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> 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@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: [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).
