http://www.orafaq.com/faq/import_export
Exp exports - imp imports it again. Use exp on the source DB and imp on the target DB and your DB migration is done. On 2/23/07, Nick G <[EMAIL PROTECTED]> 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. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2746 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6
