Re: Is there an option for insert statements/DML to be captured similar to DDLs generated with import imp show=y
Date: Wed, 7 Oct 2009 15:06:12 -0700
Message-ID: <bf46380910071506o7f21c9e8h954584e60b554df2_at_mail.gmail.com>
You seem to be asking if exp will capture DML statementsthat are currently in the SQL Cache.
If my understanding is indeed correct, then the answer is 'no'.
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 2:05 PM, sundar mahadevan < sundarmahadevan82_at_gmail.com> wrote:
> Hi Gurus,
> I would like to know if there is any option or a package like DBMS_
> that would give the insert sql statements or dml statements required
> for an import with an export dump. I have an export dump exp.dmp and
> imp show=y generates DDL statements and also imp indexfile=filename
> generates DDL statements from the export dump. Is there a similar
> option for DML/insert statements? My requirement is to only write DML
> statements to a file and later execute it with sqlplus. This is not a
> real time scenario but for my knowledge. Thanks in advance.
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Oct 07 2009 - 17:06:12 CDT