Hi all

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