#DateForumTypeThreadPost
415 Jun 2016 @ 11:52 PDTDatabaseReplyCopying trillions of data to new tableRaj, Do you really need to partition the date for everyday ? If possible, try to increase the partition to a month or quarters, then try running the delete SQLs. Also look at the period of dates ...
330 May 2016 @ 06:46 PDTDatabaseReplyCopying trillions of data to new tableYeah. Most of them being used in different reports. Some are multicolumn NUSI, and most are single column NUSI. Our purpose is to do mirror copy from OLTP to MART. Instead of loading entire reco...
226 May 2016 @ 04:09 PDTDatabaseReplyCopying trillions of data to new tableadding to the above: All the tables have 5+ secondary indices(NUSI).    
126 May 2016 @ 12:03 PDTDatabaseReplyCopying trillions of data to new tableHi Dieter,  We have a mirror database concept where data from t1 table is copied into t2 & t3 tables. All  t1, t2 & t3 tables have same DDL definitionand everytime it is a compl...