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 (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).