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: sundarmahadevan82@xxxxxxxxx
  • Date: Wed, 7 Oct 2009 15:06:12 -0700

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:
Home Page:

On Wed, Oct 7, 2009 at 2:05 PM, sundar mahadevan <
sundarmahadevan82@xxxxxxxxx> 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.
> --

Other related posts: