Nick G wrote: > Hi, I'm sorry that I am reposting this question again but I felt I > didn't explain myself well enough before. I am looking for a way to > re-create existing schemas in an Oracle database (9i and 10G)....not > just create a back up. These re-created schemas needs to have all > associated properties; tables, sequences, triggers, data, etc. The > Oracle tool IMP/EXP appears to only put the selected tables into > binary format which are used exclusively for backup purposes. I very > well may be wrong in assuming that but from what I've read so far > indicates that. If I am wrong, does anyone know where I can find step > by step "explain it like I'm a four year old" instructions that will > explain using IMP/EXP? Thanks again. >
Aqua Data studio has pretty good DDL scripting...I've only used it for MS-SQL, MySQL and PostgreSQL, but it supports Oracle as well... http://www.aquafold.com/index-oracle.html ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 and Flex 2 Build sales & marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2 Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2745 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6
