Comments on The PeopleSoft DBA Blog: PeopleSoft and the Oracle Recycle Bin

Hi, I read the post at http://thinktibits.blogspot.com/2009/08/peoplesoft-and-recycle-bin.html and still agree with what David has said!

because there always is the possibility of the rec...

2009-09-22T16:26:04.544+01:00

because there always is the possibility of the recycle bin being useful, I've kept it on in my PeopleSoft databases. however, when performing the once-a-week cold backup, I automatically purge the dba_recyclebin; otherwise, it would grow to unmanageable proportions.

i) I generally avoid using alter in place scripts ...

2009-08-28T09:59:50.520+01:00

i) I generally avoid using alter in place scripts (which generally use ALTER TABLE commands) in a production system. I prefer to recreate tables because adding and populating new columns can lead to row migration.

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.

I didn't say you shouldn't use the Recycle Bin. However, it is enabled by default, and most developers don't realise that. The result is lots of debris builds up.

I would use it selectively in non-development environments.

Hey, nice post! What is your response to http://...

2009-08-28T09:36:12.800+01:00

Hey, nice post!

What is your response to

http://thinktibits.blogspot.com/2009/08/peoplesoft-and-recycle-bin.html

Cheers,