| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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_at_TDWater To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
house.com> cc:
Sent by: Subject: RE: Creating new user
root_at_fatcity.com
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..
-----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 (phil_wilson_at_smartforce.com)
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 <ORACLE-L_at_fatcity.com>
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_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: Deshpande, Kirti INET: kirti.deshpande_at_verizon.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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: JayMiller_at_TDWaterhouse.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). <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<---->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> Privileged/Confidential information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone. In such case, you should destroy this message and kindly notify the sender by reply e-mail or by telephone on (61 3) 9612-6999. Please advise immediately if you or your employer does not consent to Internet e-mail for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of Transurban City Link Ltd shall be understood as neither given nor endorsed by it. <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<---->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Richard INET: mrichard_at_transurban.com.au 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 - 18:43:56 CDT
 |
 |