Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: how to export tables and contents in SQL files ? ( Version 7.3)
Michael Agbaglo wrote:
>
> As far as I understood the man, EXP can only create 'native' files that are
> intended to use with IMP. But I like to have an SQL-Script for all user
> tables and constraints... Contents can be in seperate files...
> Informix can do this with 'dbschema', I think - I can't imagine that
> there's nothing available under Oracle...
imp show=y log=file will give you the ddl into a flat file Received on Wed Feb 19 1997 - 00:00:00 CST