Re: Is there an option for insert statements/DML to be captured similar to DDLs generated with import imp show=y
- From: Mathias Magnusson <mathias.magnusson@xxxxxxxxx>
- To: jkstill@xxxxxxxxx
- Date: Thu, 8 Oct 2009 07:31:18 +0200
I think the request here is to convert the data in the dmp file into insert
statements required to "load" that data into a table. I do not thing it is
about capturing running SQLs in the DB or the statements that was used to
get the data into the table. Is this correct?
I don't think it is possible to get it automatically other than by capturing
statements as the imp job runs (maybe via log miner).
If this is correct, try taking one step back and explaining the problem you
need to solve rather than the solution to your perceived problem that has
led you to another problem (unless this isn't the original problem somehow +
in which case understanding a little more about that would be helpful)
Mathias
On Thu, Oct 8, 2009 at 1:10 AM, Jared Still <jkstill@xxxxxxxxx> wrote:
> I think I had it correctly the first time.
> Just exactly what DML do you expect to find in an export?
>
> What is it you are really trying to do?
>
>
> Jared Still
> Certifiable Oracle DBA and Part Time Perl Evangelist
> Oracle Blog: http://jkstill.blogspot.com
> Home Page: http://jaredstill.com
>
>
>
> On Wed, Oct 7, 2009 at 3:22 PM, sundar mahadevan <
> sundarmahadevan82@xxxxxxxxx> wrote:
>
>> Let me try to reframe the questions as it seems unclear. Lets say, I
>> have an export dump exp.dmp. I then use imp system/password
>> log=import.log file=exp.dmp show=y or imp system/password
>> log=import.log file=exp.dmp indexfile=ddlcreate.log to get the DDL
>> commands to be written to ddlcreate.log. Is there a similar
>> option/method to write insert statements/dml to a file named
>> dmlcreate.log? Please let me know if this is still unclear. Thanks in
>> advance.
>> --
>> //www.freelists.org/webpage/oracle-l
>>
>>
>>
>
Other related posts:
