|
-
Originally posted by jmodic
Don't even think of using ROWIDs or ROWNUMs for this kind of delete! It is an almost guaranteed way to delet the *wrong* records.
As advised by some wise people here, you should only rely on a reliable backup from before your insert or use a logminer if you are not able to create the reverse (delete) SQL to revert changes.
True. I would never rely on ROWID if I have to delete from PROD. I would rather do it "by hand" checking all the rows in the table. Even if they are 500 :-) And moreover, I would export the table before I delete.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|