Re: IMPORT DATA
Date: 4 Jan 95 02:02:23
Message-ID: <ALAW.95Jan4020223_at_ap226sun.oracle.com>
In article <b09-030195144351_at_macaux.nikhef.nl> b09_at_nikhef.nl (Jeroen Hermans) writes:
> During my vacation someone deleted a record from the database.
> Every night I make an full database export.
> I have a file fulldump from tape and the record is backed-up in this file.
>
> How can I retrieve only one record from one table from the fulldump.
> I can get no information from the "Utilities User's Guide" how to retrieve
> one record, I only get information about retrieving the entire table.
If your table has an unique index, you can import the entire table and specify "Ignore errors" to "Yes", and import will ignore all the ORA-0001 unique constraint violation/duplicate key in index errors.
Assuming you have DBA privilege, you can create a dummy account and import the table into the dummy account and recreate the missing row with INSERT/SELECT.
Or if you are brave enough (big disclaimer), you can actually save the export file into a dummy file and edit the dummy export file to eliminate all the unwanted rows.
-- ___ (o o) +-oo0-\_/-0oo---------------------------------------------------------------+ | Alvin Law .. Project Leader, Applications Division ... Oracle Corporation | | Email: alaw_at_us.oracle.com ..... Voice: 415.506.8317 . Fax: 415.506.7299 | +---------------------------------------------------------------------------+ ORA-03113: end-of-file on communication channelReceived on Wed Jan 04 1995 - 02:02:23 CET