tag:blogger.com,1999:blog-4129346287195722005.post6284944869896615182..comments2024-03-10T22:04:19.953-07:00Comments on ThinkTibits!: PeopleSoft and Recycle BinAnonymoushttp://www.blogger.com/profile/07717408059667602415noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-4129346287195722005.post-1758586194290482402010-04-19T00:54:26.528-07:002010-04-19T00:54:26.528-07:00But DDL statements implicitly commit any transacti...But DDL statements implicitly commit any transaction before they start!David Kurtzhttps://www.blogger.com/profile/00924323960047469300noreply@blogger.comtag:blogger.com,1999:blog-4129346287195722005.post-91820172231826636952009-09-01T20:18:11.896-07:002009-09-01T20:18:11.896-07:00Read this post. With my experience in PeopleSoft, ...Read this post. With my experience in PeopleSoft, I feel that application designer is not a comfortable tool to create / modify objects when it comes to PeopleSoft / Oracle DB. For example, it gives COMMIT statements after every DDL. I always prefer to edit the file my myself and run it in SQLPLUS or any other client for that sake. If that is the case, adding a PURGE should not be a problem. Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-4129346287195722005.post-39203929146967156162009-08-28T02:05:19.221-07:002009-08-28T02:05:19.221-07:00Since you have commented on my blog, I thought I w...Since you have commented on my blog, I thought I would reply here.<br /><br />i) I generally avoid using ALTER TABLE in a production system. I prefer to recreate tables because adding and populating new columns can lead to row migration.<br /><br />ii) You cannot get Application Designer to automatically add the PURGE option to DROP TABLE commands. You have to go in there and add them manually.David Kurtzhttps://www.blogger.com/profile/00924323960047469300noreply@blogger.com