If so you can a put the two indexes on c3 unused b update with parallel dml maybe c3 c rebuild the two indices as it seems as if there would be less work. How do I try a solution also try to put some of the data from our European pages into a central archive and since I do not have access to these pages yet I can not just test it because we do not have any 7.3.4 pages god in the united states If i do not enable PDML and INSERT run serially Oracle starts writing to the temp y segments in the table space of the target table as soon as the source result is available. It not a clean solution because all primary keys are included. The same amount so a number x must be added to the primary key psuedo key and subkey in each form to avoid dups.Tom: Qn having a table Data created from another table - I want to make a table with few fields and collect a few columns from another table. Tom recently I had an interview where one of the dba mentioned that they had a table that millions of records could contain may be 1 million. But before i try to merge the data with the original tables I would have to adjust the primary key for all tables and update the foreign important references entsprechend.Tom it still okay if these steps create delete a new table the old and rename on the new table like the old create indexes etc. is coded as a batch update program. It shows you how this session has been waiting in this range while measuring the number of lines - because the number of lines reduces the number of waiting events. And this table is not indexed correctly should probably add the algorithm if the table has virtual columns and that this may work only in 12c .
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
November 2018
Categories |