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_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: 
  INET: maheswara.rao_at_sungard.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).