Re: Is there an option for insert statements/DML to be captured similar to DDLs generated with import imp show=y
- From: Jared Still <jkstill@xxxxxxxxx>
- To: Mathias Magnusson <mathias.magnusson@xxxxxxxxx>
- Date: Thu, 8 Oct 2009 09:30:27 -0700
Ah, sorry, I misunderstood.
My new answer: "I don't know"
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 10:31 PM, Mathias Magnusson <
mathias.magnusson@xxxxxxxxx> wrote:
> 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:
