| Generate SQL DDL from export file [message #69856] |
Wed, 13 March 2002 16:35  |
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!
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
