Hi Tony, to point 1 UPDATE GLOBAL INDEXES is a 9i feature compare (8.1.7) http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a85397/statem2a.htm#2056642 and http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96540/statements_32a.htm#2114058 so your statement with UPDATE GLOBAL INDEXES is syntactically wrong. to point 2 the index structure of the temp table table should correspond with the *local* indexes of the partitioned table, so I guess the "global" index on the temp table should be removed. A possible strategy - I'd would follow - try to test all with local index only. If it works add the global index on the partitioned tables only. HtH Jaromir > /* > Hi Oracle partitioning gurus, > I am trying to setup a group of tables partitioned on a date column so > that monthly > a new partition can be added and the oldest partition can be archived. > > > -- > //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l
