exp & imp or database tables
Posted on 2007-04-10
I need to replicate some tables on database A to database B. I can use EXP and IMP utility to take a backup of all the tables on A and import them onto B but i have some questions to ask, suppose i want to backup 5 tables T1,T2,T3,T4 & T5
1. Can i have a backup of just the STRUCTURE and no data of the table T1 on A using EXP? If yes, is there any different options to be given to IMP to import it on the database B.
2. If the tables, T1,T2,T3,T4 & T5 have any indexes, constraints or dependency tables, what is the approach to follow with EXP to export the tables with all the indexes, constraints and dependency tables in consistent with each other and how to import them?
Any information will be of a great help.