Manish, Just for clarification, are you saying that you are allowing users to access the system while making administrative changes? Bad mojo, if you are. The process you are talking about is normal (creating a copy of the table, rebuilding the table, and moving the data back in... this process is all described in one of the manuals, I believe.. I'd have to go find the reference), but best practice would be to lock users out of the system when making form and workflow changes.
Good luck, Matt R. -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Manish SINGLA Sent: Wednesday, October 20, 2010 10:17 AM To: [email protected] Subject: URGENT : TABLE Space settings and T Table behaviour on form modification Hello List, We have realized some delay in appearing of "T" table w.r.t Helpdesk while creating or altering some field and saving the form. Now could you please advise me what should be settings at DB Oracle's (10G) end. 1. While saving Helpdesk table "T369" for helpdesk, it creates A369 table and T369 table dis-appears, is this normal. 2. When Helpdesk "T" table disappears helpdesk starts giving error Table and view doesn't exist, what should be done to save this pattern. 3. What should be TEMP TABLE Space size when Helpdesk "T" table size is "10 GB" or has no relation to Helpdesk "T" table size. 4. On Helpdesk Form modification, what are the possible cases when indexes drops. 5. What else can be impacts more on Helpdesk form if appropriate TEMP space not found. Thanks to share the above asked question ASAP, is bit urgent to know. Best Regards Manish ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
