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 Weatherman Database Administrator Replacements Ltd. -----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 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: John Weatherman INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).