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 -> Re: Exporting just DML's

Re: Exporting just DML's

From: Howard J. Rogers <howardjr_at_www.com>
Date: Sat, 21 Oct 2000 00:47:08 +1000
Message-ID: <39f04d50$1@news.iprimus.com.au>

Comments below.
HJR

--
--------------------------------------------------------------------------
Opinions expressed are my own, and not those of Oracle Corporation
Oracle DBA Resources:               http://www.geocities.com/howardjr2000
--------------------------------------------------------------------------

"Reve Cristo" <rcristo_at_my-deja.com> wrote in message
news:8sibth$86b$1_at_nnrp1.deja.com...

>
>
> I am trying to export just the data for a couple of tables. But it
> seems that I can only export the table as a whole, with the DDL and DML
> commands.
> How can I export just the DML commands?
>
First, I would point out that the DDL commands in an export file are really irrelevant, in the sense that when you run import, you can say 'ignore=y', and as a result the 'create table blah' statements in the dump file are effectively skipped... import just gets on to doing the 'insert into blah' commands (hence, import can be persuaded to ignore the DDL and just perform the DML statements). Second, if you are genuinely interested in merely the transactions which have affected a table since a given point, then (assuming you have Oracle 8i), you can use the Log Miner utility to mine for all DML statements that have affected any specified table (select sql_redo from v$logmnr_contents where seg_name='blah';) Regards HJR
> note: I am doing this from the command line using the exp (with
> parameters) command on NT.
>
> Thanks for any help.
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Fri Oct 20 2000 - 09:47:08 CDT

Original text of this message

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