Santosh, imp should be available on the machine if Oracle software is installed on the machine.
Perhaps that machine might be having more than one disk and Oracle software would have been installed on another disk. Do the following: Check the number of disks. Then on each disk --- try to find dir imp* Rao -----Original Message----- Sent: Tuesday, October 22, 2002 9:15 AM To: Multiple recipients of list ORACLE-L but my friend... i gave the command "dir imp*" and there are no files found... so now where and how and what do i use my imagination.... santosh -----Original Message----- Sent: Tuesday, October 22, 2002 6:25 PM To: Multiple recipients of list ORACLE-L There were imp73 and imp80 for appropriate versions, I don't know about more recent ones Use your imagination, friend! :-) Gints Plivna, Softex Latvia, Tel. 7204520 Fax 7204260 http://www.softex.lv -----Original Message----- Sent: otrdiena, 2002. gada 22. oktobri 15:19 To: Multiple recipients of list ORACLE-L 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----- Nahata 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: Gints Plivna 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.com -- Author: Santosh Varma 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.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).
