CODEWITHSUNDEEP
sqloracle-databaseimpdpdmp
wiegehtdasblos
wiegehtdasblos

Reputation: 11

Translate oracle-dmp with data into sql file

I want to create an SQL file from an Oracle DMP file.

With the command

"impdp [system] / [password] DUMPFILE = dampfilename.dmp SQLFILE = sqlfilename.sql logfile = logfilename.log full = Y show = y"

only the structure is in the sql file. When I look into the DMP file with a HEX editor, the data is included.

[system] / [password] are the same ones that were used with beo expdp.

I'm using release 11.2.0.1.0

Upvotes: 1

Views: 3384

Answers (1)

Roberto Hernandez
Roberto Hernandez

Reputation: 8518

The parameter SQLFILE for the Import datapump specifies a file into which all of the SQL DDL that Import would have executed, based on other parameters, is written.

If SQLFILE is specified, then the CONTENT parameter is ignored if it is set to either ALL or DATA_ONLY. That is because SQLFILE only will show DDLs included in the datapump file.

Putting SQLFILE does not exeucte anything in the target database where you are running the impdp, it will only write a file in the directory you have specified on the parameter directory.

Summary: Import datapump will not write any dml to the sqlfile

Upvotes: 1

Related Questions