Home » RDBMS Server » Server Utilities » Generate SQL DDL from export file
Generate SQL DDL from export file [message #69856] Wed, 13 March 2002 16:35 Go to next message
orafan
Messages: 8
Registered: December 2001
Junior Member
Hello,

I want to use the IMPORT utility to generate all the DDL statement from the export dump file.

[[oracle@localhost oracle]]$ imp system/manager parfile=param.dat

and the content of param.dat file is:
file=expdat.dmp
show=y
full=y
log=dd.sql
indexfile=idx.sql
rows=n

The command execute successfully,but in the log file (dd.sql), there is no SQL statement at all, only some information of the import utility. In indexfile, all the SQL statements to create the index are generated.

If I use the interactive mode of import, all the SQL statement can be shown in the screen.

Could anyone tell me how to save these DDL SQL statement in the log file? Thanks in advance!

Report message to a moderator

Re: Generate SQL DDL from export file [message #69866 is a reply to message #69856] Thu, 14 March 2002 08:25 Go to previous message
Grant
Messages: 578
Registered: January 2002
Senior Member
Remove indexfile=idx.sql from the parameter file. You can only do one or the other. The SHOW option will give all object create statements including indexes.

Report message to a moderator

Previous Topic: log miner
Next Topic: sql.bsq
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Jan 23 14:58:12 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.