With Oracle, you can log in with sqlplus and do something like this: (Obviously, you'd have to fill in the schema names, passwords, instance names, table names, etc.)
//disable all constraints MODIFY CONSTRAINT myconstraintname DISABLE; //disable any triggers that might fire ALTER TRIGGER mytrigger DISABLE; //delete old data from table you want to refill DELETE FROM myschema.mytable; //copy from the other instance and insert into this instance COPY FROM oldschemaname/password@instancename- TO newschemaname/password@instancename - INSERT tabletoinsertinto- USING SELECT * from schemaname.oldtablename; //reenable any triggers ALTER TRIGGER mytrigger ENABLE; //reenable any constraints ALTER TABLE mytable MODIFY CONSTRAINT myconstraint ENABLE; Deanna Schneider Interactive Media Developer [EMAIL PROTECTED] ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
