Re: Oracle 6 Import Please Help

Yes, you can import into an existing table (empty or otherwise), but you need the option IGNORE=Y, which tells it not to worry about errors when creating the table. If the table isn't empty you may get problems with unique keys. If you've amended the structure of the table (eg adding columns, making nullable columns not null) then you may also have problems with inserts. In this case RENAME the existing table, run the IMPORT, and move the data into the tables with an INSERT after you've remedied any problem data.  After you've got it sorted, you may want to do a proper EXPORT/IMPORT to tidy it all up/ensure that you've got a backup which works.  Gary

-- 
Gary Myers, Analyst/Programmer, Kaisha Technology, West of England