Re: Export and Import Utility
From: Steve Edelstein <74160.645_at_CompuServe.COM>
Date: 1995/06/13
Message-ID: <3rkdoq$528$1_at_mhadf.production.compuserve.com>#1/1
Date: 1995/06/13
Message-ID: <3rkdoq$528$1_at_mhadf.production.compuserve.com>#1/1
Anytime I've done something like that I've always used temp tables to import the data. Putting them into the base tables seems like a bad idea: what if 2 users import the same data into the base table at the same time? What happens to unique indexes/constraints/etc? Importing into temps lets the users play around without damaging the base tables. The proc can then delete the data at the end of the ad-hoc situation (or when the user says to). To prevent collisions in the temps, you can use some unique id, like the userid, to make each set unique, so if 2 users import the same data, it's always distinct from other sets.
-- Steve Edelstein VOICE: 212-956-3670 Relational Business Systems CompuServe: 74160,645 124 West 60th Street Suite 47C Author of New York, NY 10023 "Learning Oracle Forms"Received on Tue Jun 13 1995 - 00:00:00 CEST