Re: Cannot add column to partitioned table
oamdelaytestresultentity is the table for raw data, partitioned by date for 3 month. I have hourly and daily aggregated tables on the raw data.
oamdelaytestresulthourly - 33 partitions / 18K records
oamdelaytestresultdaily - 14 partitions / 4K records
alter table oamdelaytestresultdaily add column sumOfSquaresRoundTripTime bigint(20) DEFAULT 0;
works fine. I do not need to truncate the data.
alter table oamdelaytestresulthourly add column sumOfSquaresRoundTripTime bigint(20) DEFAULT 0;
fails with 18K records in the table. If I truncate the data from the table, it works.
Subject
Views
Written By
Posted
3436
July 31, 2015 02:25PM
Re: Cannot add column to partitioned table
1452
August 01, 2015 04:24PM
1352
August 01, 2015 05:21PM
1163
August 01, 2015 05:54PM
1208
August 02, 2015 03:30PM
1202
August 03, 2015 10:49AM
1175
August 03, 2015 05:42PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.