copying tables from one database to another in oracle
I have 3 translation tables,i.e,camp_generic_trans
these tables exist in cntr1/cntr1@camABC1
I have to copy these tables from here to staging environment.
I need to first check if any of the tables exist in staging.If yes,then delete and create new.
There are 4 staging env from 5 to 8.
I have to pass the staging environment as parameter to ask the user which environment does he want the tables to be copied.
Any suggestion would highly be appreciated as I am new to unix.Thank you so much in advance