Re: Please need some help on imp

Bill,

     Where are you trying to load the data to? Do the tables already exist? If so, then use the ignore=y option and it won't complain if the table already exists when it tries to create it, but it will load the data into it.

Bill Conner wrote:

> Hi All,
>
> i am starting to feel real dumb, have RTFM for oracle utilities on imp/exp 3
> times but don't seem able to get the imp to just load the data and not the
> tables as well. Am running solaris 8 &oracle 8.1.7 anything that i might
> not be seeing would be very much appreciated!!!!!!
>
> TiA!!!!!!!!!!!!
>
> -bill
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Bill Conner
> INET: bill.conner_at_clarent.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> 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).

--
Scott Canaan (srcdco_at_rit.edu)
(585) 475-7886
"Life is like a sewer, what you get out of it depends on what you put into it" -
Tom Lehrer


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Scott Canaan
  INET: srcdco_at_ritvax.rit.edu

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).