Help - Moving data using db_link

From: salu Ullah <salu_ullah_at_hotmail.com>
Date: Thu, 01 Jun 2000 19:31:25 GMT
Message-Id: <10515.107455@fatcity.com>

Hello,

We have 2 database running on 2 seperate machine one used for production data & the other one for temp data.
Once the user is done inserting data in 45 tables in temp database, all the information needs to be moved over production database. A dabase link is created on production database that can access temp database. Want to know if creating a cursor can insert all data over production & delete it from temp database. If it can be done then how can i handle 45 tables in one cursor?
Is there any other alternate.

Any suggestion would be appreciated.

Thanks

Salu

---

Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com Received on Thu Jun 01 2000 - 14:31:25 CDT