dbTalk Databases Forums  

DDLs from a .dmp file

comp.databases.oracle.misc comp.databases.oracle.misc


Discuss DDLs from a .dmp file in the comp.databases.oracle.misc forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
raghu
 
Posts: n/a

Default DDLs from a .dmp file - 07-13-2006 , 02:25 PM






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

Thanks,


Reply With Quote
  #2  
Old   
raghu
 
Posts: n/a

Default Re: DDLs from a .dmp file - 07-13-2006 , 02:51 PM







raghu wrote:
Quote:
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?



Reply With Quote
  #3  
Old   
Maxim Demenko
 
Posts: n/a

Default Re: DDLs from a .dmp file - 07-13-2006 , 03:08 PM



raghu schrieb:
Quote:
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


Reply With Quote
  #4  
Old   
Frank van Bortel
 
Posts: n/a

Default Re: DDLs from a .dmp file - 07-14-2006 , 02:39 AM



Maxim Demenko schreef:

Quote:
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
I must say, I've never seen a more polite way of hinting RTFM
--
Regards,
Frank van Bortel

Top-posting is one way to shut me up...


Reply With Quote
  #5  
Old   
Maxim Demenko
 
Posts: n/a

Default Re: DDLs from a .dmp file - 07-14-2006 , 05:17 AM



Frank van Bortel schrieb:
Quote:
Maxim Demenko schreef:
....
I must say, I've never seen a more polite way of hinting RTFM
;-)


Best regards

Maxim


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.