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

Home -> Community -> Mailing Lists -> Oracle-L -> Exp Imp Overwirte posiible or not?

Exp Imp Overwirte posiible or not?

From: <azhar_at_mathtech-pk.com>
Date: Tue, 27 Mar 2001 00:39:52 -0800
Message-ID: <F001.002D878E.20010326234547@fatcity.com>

Hi All,
 I want to import data from a user dump file but when i import data, i want to overwrite the existing data . Normally imp utility append data to existing rows. Requirement of application is such that we need to overwrite existing data without dropping objects and its dependent objects. Is it possible with exp , imp utilities or i have to delete data first and then import using imp utility. Is there any other possibility...
Environment Oracle8i, Windows NT4
TIA Azhar Siddiq

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
  INET: azhar_at_mathtech-pk.com

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: ListGuru_at_fatcity.com (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). Received on Tue Mar 27 2001 - 02:39:52 CST

Original text of this message

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