Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Exporting just DML's
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...Received on Fri Oct 20 2000 - 09:47:08 CDT
>
>
> 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.