RE: Creating new user
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-From: Santosh Varma [mailto:[EMAIL PROTECTED]]Sent: Tuesday, October 22, 2002 5:14 PMTo: Multiple recipients of list ORACLE-LSubject: 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
Re: Creating new user
Santosh, you need to either: 1. take a DBA course 2. go to technet.oracle.com and start reading the administrators guide. joe Santosh Varma wrote: 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: Joe Testa 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).
RE: Creating new user
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-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Naveen NahataSent: Tuesday, October 22, 2002 5:40 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Creating new user 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-From: Santosh Varma [mailto:[EMAIL PROTECTED]]Sent: Tuesday, October 22, 2002 5:14 PMTo: Multiple recipients of list ORACLE-LSubject: 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
RE: Creating new user
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: [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).
RE: Creating new user
Thanks Naveen santosh -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Naveen NahataSent: Tuesday, October 22, 2002 5:40 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Creating new user 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-From: Santosh Varma [mailto:[EMAIL PROTECTED]]Sent: Tuesday, October 22, 2002 5:14 PMTo: Multiple recipients of list ORACLE-LSubject: 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
RE: Creating new user
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. oktobr 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).
RE: Creating new user
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. oktobr 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).
RE: Creating new user
Oh yea, my fault, didn't read mail till the end Blah, I don't know, usually if I had installed various oracle client tools like Designer, Forms, Reports etc I had also imp*. I'm sure it isn't as a standalone tool in installer, maybe it is located under tools/utilities, if I remember correctly... Last time when I installed something from oracle was at least 1.5 years ago :( Gints Plivna, Softex Latvia, Tel. 7204520 Fax 7204260 http://www.softex.lv -Original Message- Sent: otrdiena, 2002. gada 22. oktobr 16:15 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. oktobr 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: 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).
Re: Creating new user
What kind of client do you have? Maybe the install installed only net8 without the utilities? Check if you have exp*. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, October 22, 2002 3:14 PM 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. oktobr 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: Yechiel Adar 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).
RE: Creating new user
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).
RE: Creating new user
If it is windows, you'll have to use dir imp*.* to capture those with extensions of .exe Phil Wilson ([EMAIL PROTECTED]) DBA, Operations Group SkillSoft, Learning Solutions for the Human Enterprise 506.462.1124(w) 506.447.0334(c) -Original Message- Sent: Tuesday, October 22, 2002 10:49 AM To: Multiple recipients of list ORACLE-L What kind of client do you have? Maybe the install installed only net8 without the utilities? Check if you have exp*. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, October 22, 2002 3:14 PM 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. oktobr 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: Yechiel Adar 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: Phil Wilson (DBA) 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).
RE: Creating new user
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).
RE: Creating new user
Not really. dir imp* will list all files which start with 'imp' so it will list imp.exe, imp80.exe, imp.log etc But I'm clueless as to why there is nothing like imp or imp80 in the %oracle_home%/bin. Use some other machine to do the import, is the only solution i can offer Regards Naveen -Original Message- Sent: Tuesday, October 22, 2002 7:44 PM To: Multiple recipients of list ORACLE-L If it is windows, you'll have to use dir imp*.* to capture those with extensions of .exe Phil Wilson ([EMAIL PROTECTED]) DBA, Operations Group SkillSoft, Learning Solutions for the Human Enterprise 506.462.1124(w) 506.447.0334(c) -Original Message- Sent: Tuesday, October 22, 2002 10:49 AM To: Multiple recipients of list ORACLE-L What kind of client do you have? Maybe the install installed only net8 without the utilities? Check if you have exp*. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, October 22, 2002 3:14 PM 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: Yechiel Adar 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: Phil Wilson (DBA) 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
RE: Creating new user
Probably he is not in %ORACLE_HOME%/bin directory. A 'Find' for imp* on all drives would tell where it is hiding.. - Kirti -Original Message- Sent: Tuesday, October 22, 2002 9:34 AM To: Multiple recipients of list ORACLE-L Not really. dir imp* will list all files which start with 'imp' so it will list imp.exe, imp80.exe, imp.log etc But I'm clueless as to why there is nothing like imp or imp80 in the %oracle_home%/bin. Use some other machine to do the import, is the only solution i can offer Regards Naveen -Original Message- Sent: Tuesday, October 22, 2002 7:44 PM To: Multiple recipients of list ORACLE-L If it is windows, you'll have to use dir imp*.* to capture those with extensions of .exe Phil Wilson ([EMAIL PROTECTED]) DBA, Operations Group SkillSoft, Learning Solutions for the Human Enterprise 506.462.1124(w) 506.447.0334(c) -Original Message- Sent: Tuesday, October 22, 2002 10:49 AM To: Multiple recipients of list ORACLE-L What kind of client do you have? Maybe the install installed only net8 without the utilities? Check if you have exp*. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, October 22, 2002 3:14 PM 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: Deshpande, Kirti 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).
RE: Creating new user
He mentions checking /oracle/bin, not $ORACLE_HOME/bin. Santosh: If this is a Windows environment (as it seems to be) you can check the Registry Editor for the value of ORACLE_HOME (it should be under HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE) -Original Message- Sent: Tuesday, October 22, 2002 12:05 PM To: Multiple recipients of list ORACLE-L Probably he is not in %ORACLE_HOME%/bin directory. A 'Find' for imp* on all drives would tell where it is hiding.. - Kirti -Original Message- Sent: Tuesday, October 22, 2002 9:34 AM To: Multiple recipients of list ORACLE-L Not really. dir imp* will list all files which start with 'imp' so it will list imp.exe, imp80.exe, imp.log etc But I'm clueless as to why there is nothing like imp or imp80 in the %oracle_home%/bin. Use some other machine to do the import, is the only solution i can offer Regards Naveen -Original Message- Sent: Tuesday, October 22, 2002 7:44 PM To: Multiple recipients of list ORACLE-L If it is windows, you'll have to use dir imp*.* to capture those with extensions of .exe Phil Wilson ([EMAIL PROTECTED]) DBA, Operations Group SkillSoft, Learning Solutions for the Human Enterprise 506.462.1124(w) 506.447.0334(c) -Original Message- Sent: Tuesday, October 22, 2002 10:49 AM To: Multiple recipients of list ORACLE-L What kind of client do you have? Maybe the install installed only net8 without the utilities? Check if you have exp*. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, October 22, 2002 3:14 PM 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: Deshpande, Kirti 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: Miller, Jay 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).
RE: Creating new user
Santosh, Are you looking on your client, or the server where Oracle is installed? imp can be installed in either location - as others have mentioned, expect it on the server by default, but not the client. My preference would be to work on the server if possible since it removes the network and can therefore be quicker. Also, for what it's worth, I have an 8.1.7.4 client installed here and imp is called imp.exe, installed in \oracle\ora81\bin - But since they like to move things around all the time that piece of info is probably useless. Miller, Jay JayMiller@TDWater To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] house.com cc: Sent by: Subject: RE: Creating new user [EMAIL PROTECTED] 23/10/2002 04:14 Please respond to ORACLE-L He mentions checking /oracle/bin, not $ORACLE_HOME/bin. Santosh: If this is a Windows environment (as it seems to be) you can check the Registry Editor for the value of ORACLE_HOME (it should be under HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE) -Original Message- Sent: Tuesday, October 22, 2002 12:05 PM To: Multiple recipients of list ORACLE-L Probably he is not in %ORACLE_HOME%/bin directory. A 'Find' for imp* on all drives would tell where it is hiding.. - Kirti -Original Message- Sent: Tuesday, October 22, 2002 9:34 AM To: Multiple recipients of list ORACLE-L Not really. dir imp* will list all files which start with 'imp' so it will list imp.exe, imp80.exe, imp.log etc But I'm clueless as to why there is nothing like imp or imp80 in the %oracle_home%/bin. Use some other machine to do the import, is the only solution i can offer Regards Naveen -Original Message- Sent: Tuesday, October 22, 2002 7:44 PM To: Multiple recipients of list ORACLE-L If it is windows, you'll have to use dir imp*.* to capture those with extensions of .exe Phil Wilson ([EMAIL PROTECTED]) DBA, Operations Group SkillSoft, Learning Solutions for the Human Enterprise 506.462.1124(w) 506.447.0334(c) -Original Message- Sent: Tuesday, October 22, 2002 10:49 AM To: Multiple recipients of list ORACLE-L What kind of client do you have? Maybe the install installed only net8 without the utilities? Check if you have exp*. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, October 22, 2002 3:14 PM 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