Re: Please need some help on imp

2002-08-30 Thread Scott Canaan
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 dum

Re: Please need some help on imp

2002-08-30 Thread Thomas Day
@clarent.com>cc: Sent by: rootSubject: Please need some help on

RE: Please need some help on imp

2002-08-30 Thread Hand, Michael T
Bill Ignore=Y is that what you're looking for? Mike -Original Message- Sent: Friday, August 30, 2002 3:44 PM To: Multiple recipients of list ORACLE-L 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

RE: Please need some help on imp

2002-08-30 Thread John Weatherman
Bill, I assume from the way you state this, you already have the tables built and don't want imp to blow up trying to recreate them. Correct? If so, try ignore=y. Also, if the user is changing, are you using "fromuser= touser="? Output from your problem might be helpful. HtH, John P Weatherm

Please need some help on imp

2002-08-30 Thread Bill Conner
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!!