copy translation tables from staging environment.
Hi
I have 3 translation tables,i.e,camp_generic_trans camp_generic_trans_def camp_generic_trans_epc 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 |
This is not a solution; but, may help.
To check if a table exists you can run: Code:
SELECT * FROM USER_TABLES WHERE TABLE_NAME='You Table Name'; Code:
DROP TABLE YOUR_TABLE_NAME; Code:
CREATE TABLE YOUR_TABLE_NAME AS Code:
INSERT INTO YOUR_TABLE_NAME |
All times are GMT -5. The time now is 11:15 AM. |