Schema Conversion to SQL File

[adewri]

Originally posted by engiri
My correction with Mr.
adewri is

The commands also can be generated by..

export the database with nodata. -->use rows=n

import the dump file with ignore=n(WHich is default)..
the failed commands will be logged into the
log file that you are specifying. (log=....)

The log file contains only the output that comes on screen while doing import or export. And its a less likely that import of valid procedure and package will fail.

You cannot get the schema objects that way except for tables and indexes. Its not at all reliable if you want to get other schema object creation scripts.