Re: newbie: how to undo data migration

may2_at_telusplanet.net (may2) wrote:

>hello; here is a newbie question I require help with; I want to use
>data migration from a draft or test table of Excel/Access data into an
>existing oracle database table; then I would like to undo the test
>table; remove only the test data from the oracle database; please tell
>me how to remove the test data after the data migration.
One way:
add a field to the target table and to the source called 'TEST' and set it to 'Y" before loading...

then delete where TEST = 'Y' to get rid of them...

----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==---- http://www.newsfeed.com The #1 Newsgroup Service in the World! >100,000 Newsgroups ---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =--- Received on Tue May 13 2003 - 11:48:34 CDT