Re: DDLs from a .dmp file

From: Maxim Demenko <mdemenko_at_gmail.com>
Date: Thu, 13 Jul 2006 22:08:40 +0200
Message-ID: <e96984$qle$02$1@news.t-online.com>

raghu schrieb:
> raghu wrote:

>> Can DDLs be retrieved from a dump file? Or is it possible to construct
>> just the schema without the data?
>>
>> Thanks,

>
>
> Actually, is it possible to modify the dump file before importing?
>

There are many ways to retrieve ddl from export files. You can import with show=y parameter and then format the ddl with any scripting language, you can use indexfile option, you can import without   data, then adjust your schema in the database and import data with ignore=y parameter, you can use the tool from http://www.databee.com/dt_home.htm to extract your ddl, probably there are some other possibilities. You should avoid to modify export file.

Best regards

Maxim Received on Thu Jul 13 2006 - 15:08:40 CDT