1)There are 2 independent AIX platform available with 10g database running on it
Mainly-Production and the other test machine
2)There is 2 tables which needs to be brought down from production to test machine
I know expdp/impdp plays the key<commands as below-correct me if the below command needs some more modifications>
expdp <userid/password> file=empdept.dmp tables=(EMP,DEPT) log=empdept.log
impdp <userid/password> file=empdept.dmp log=empdept.log
I have some clarifications to be made!
1)Its a schema level exp/import( i mean i log in as the user whose table i want to export)
2)What are Pre/Post things to be done before i take the export/Import
Request you all to please guide me for the same.Also provide me with the steps if any!
Thanks for your patience!