Manish, As Joe mentioned now with 7.5 it directly alters the table when a field is deleted from a form instead of creating a A table etc..
Ex:ALTER TABLE Txyz DROP COLUMN Cxxxxxx Earlier versions it used to take a long time to delete fields form a form having huge amount of rows i.e, because it has to create a new table ,duplicate the data into new table, delete old table and recreate the table and indices. Some times it used to timeout and end up in inconsistent state. Now with 7.5 we saw it a lot faster by avoiding those intermediatery steps. But older version if something happens in the middle A table is there for the rescue, we used to rename A table to T and its back. With 7.5 it is not possible any more unless we import the data from a db level backup. On Oct 20, 12:29 pm, Joe D'Souza <[email protected]> wrote: > Manish, > > To answer question 1, creation of A tables is normal. The AR System doesn't > do an alter table.. It creates a duplicate A table, copies information from > T to A, drops T, recreates T with the new structures, and then copies info > from A to T and then drops A.. This has been the design since the very early > versions of the ARS.. I think this has changed with the newer version, but > my mind is a bit foggy about that at the moment - I'm nursing a slight fever > and cold.. > > To answer 2, Why would you want to alter a production environment during > production hours? It is not recommended unless you have a show stopper.. And > even then you bring the system offline while repairing the show stopper if > it involves altering the main application table.. I am assuming that you > have millions of records in this table? This could mean that the whole > process of altering that table could take several minutes.. And yes the T > table will be missing during that time. No one should be allowed to be using > the application at that time. > > Answer to Q3 - The temp table size varies according to the size if the DB. > From a long time ago, I heard recommendations that it should be half the > size of the main database file.. If the database you are on, supports auto > extend or auto growth or similar options, use those so that your temp space > would not be lacking space in case there is a need for growth.. > > Answer to Q4 - Indexes normally should not automatically drop.. Once created > they should stay in existence until that field is dropped. If you drop that > field and recreate it for whatever good reason that may be, the index is > lost.. Recreate it if its needed. The only other reason I can think of why > it can possibly go missing, is if someone messed with the meta data table > field_index and deleted an index there for your table, and then modified > your helpdesk form.. Then when recreating that table, the ARS would look up > the index meta data table and create indexes for only the information that > is available.. > > Question 5 - Painfully slow performance especially when you are performing > admin tasks such as modifying large tables, writing workflow etc. Moderately > slow performance for other users.. > > Joe > > > > -----Original Message----- > From: Action Request System discussion list(ARSList) > > [mailto:[email protected]]on Behalf Of Manish SINGLA > Sent: Wednesday, October 20, 2010 11: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 atwww.arslist.org > attend wwrug10www.wwrug.comARSlist: "Where the Answers Are"- Hide quoted text > - > > - Show quoted text - _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
