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

Home -> Community -> Usenet -> c.d.o.server -> Newbie: trying to import and replace Data from Dump

Newbie: trying to import and replace Data from Dump

From: Uli <uli2003wien_at_lycos.at>
Date: 11 Jun 2004 04:04:01 -0700
Message-ID: <7643a3d9.0406110304.643c075a@posting.google.com>


Dear group,

i'm relatively new to Oracle DBA-tasks. I have the following task to do:

  1. export all Data from a user to a dump
  2. user is testing his upgrade skript
  3. if this skript fails, data will be reloaded from dump, so that user can try again.

I exported data with something like exp system/xxx_at_db file=E:\file.dmp Owner = MILLER feedback=2000 log=E:\log

this worked fine

But while doing an import from this dump using

imp system/xxx_at_db file=E:\file.dmp full=y destroy=y feedback=2000 log = E:\implog.log

i got tons of Constraint-violations.

Is there a possibility to import and replace data using the imp-Tool or the sqlldr ?

Or do i have to delete from the tables or even drop them ?

Your help is very appreciated, please respond to the group.

Thank you

Uli Received on Fri Jun 11 2004 - 06:04:01 CDT

Original text of this message

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