Got some
partitions to work on.
They are divided
by date and we've got several that this is the first month that two partitions
are in the same tablespace and shouldn't be.
But we can't stop
production.
If they are
loading "December" data, can I safely move the "September" partition at the same
time.
The data is
divided such they should not be touching it, but needless to say the index will
go invalid for that partition until the move of the index is also done. Some of
these are 2,000-5,000 meg, 176 million plus rows.
If I had just had
a bit more notice.
But I'll probably
have to start looking at this tomorrow.
Also, if I chance
the table partition name, does that invalid the matching partition index. I also
have to rename it was well. They are going 5 years, 60 months, so M1, M2, M3
ain't going to cut it. We want to go to x_200309, x_200310, x_200311,
etc.
Thanks.
Michael
Kline, Principal Consultant
Business To Business Solutions, LLC
Richmond,
VA
804-744-1545
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Michael Kline
INET: mkline1_at_comcast.net
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Thu Jan 15 2004 - 20:14:27 CST
