| Deleteing Data from TCA tables [message #506354] |
Sun, 08 May 2011 20:50  |
 |
npatel29
Messages: 1
Registered: May 2011
Location: Brisbane Australia
|
Junior Member |
|
|
As part of migration from SQL Server system, we are creating data in the EBS (TCA) tables using APIs. Is there a way to delete this data as well so we can re-run the migration in test environment multiple times.
Thanks in advance.
|
|
|
|
| Re: Deleteing Data from TCA tables [message #506427 is a reply to message #506354] |
Mon, 09 May 2011 04:42  |
John Watson
Messages: 8962
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
It is difficult (probably impossible) to "delete" the results of your test, because of all the dependencies.
Probably the best way is to use Database Flashback: get the DB into the state you want at the start of a test run, and create a savepoint. then you can test and flashback as often as necessary.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
