Copy all table data from one schema to another
I have to move data from test environment to production.
we have 2 schema (1.Dev and 2.Prod)
All our datas are in "Dev" schema.
Now we need to move it in to Prod schema..
Tables are already existing in Prod schema..
What I need to do is
1)Just move all the data from Dev to Prod
2)Delete all the data from Dev
note : I dont want to use the command insert into prod.table_name select * from dev.table_name;
reason is we have more than 500 tables in database. so I wanted to move all the table datas with out specifying the table names individually.
Other details ==> Oracle 10g on windows server 2003 .Connecting oracle using Toad 9.1
please helpme on this..
Thanks in advance