Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Import data

Import data

From: Sashi <smalladi_at_gmail.com>
Date: Mon, 16 Jul 2007 17:28:12 -0700
Message-ID: <1184632092.194564.282340@o61g2000hsh.googlegroups.com>


Hi All,

I need to import data from an existing data dump file. The problem is that I need to overwrite existing tables. Since the import command doesn't give this option (very surprising), I'm wondering what to do. I don't want to drop all the tables as that might make my views, indexes etc go out of sync.

Is there a way of keeping my tables and importing the existing data? The source and destination schemas are in sync.

Thanks,
Sashi Received on Mon Jul 16 2007 - 19:28:12 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US