RE: Creating new user

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. 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_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: Gints Plivna
> INET: G.Plivna_at_softex.lv
>
> 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: Santosh Varma
> INET: vsantosh_at_psi.soft.net
>
> 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: Yechiel Adar
  INET: adar76_at_inter.net.il

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: Phil Wilson (DBA)
  INET: Phil_Wilson_at_smartforce.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).