Re: Partitioning problems - Oracle 8.1.7.4
- From: Tony.Adolph@xxxxxx
- To: jaromir@xxxxxxxxxxxx
- Date: Mon, 7 Feb 2005 11:14:47 +0100
Hi Jaromir & Tim,
Thanks for your feedback.
I've taken on board what you've pointed out...
When I drop the global index on my temp table, I get the same error, so I
dropped the local index and
recreated the global.
So on my temp table I now only have the global index:
SQL> create index I_TONYTAB_TEMP_1 on
2 TONYTAB_TEMP (CUSTOMER_ID,SERVICE_ID)
3 tablespace PAGENTX00 pctfree 10 initrans 2 maxtrans 255
4 storage (initial 1k next 1k minextents 1 maxextents 121 pctincrease
0);
Index created
SQL> alter table TONYTAB exchange partition P01 with table TONYTAB_TEMP
including indexes without validation;
Table altered
Which seems to be opposite to what you are suggesting :-(
Also the exchange causes the PK index on the main table to go UNUSABLE
which I guess makes sense, but
is bad news. I suppose the 9i option UPDATE GLOBAL INDEXES fixes this?
Regarding the archive table: Because I have a global PK index I thought
that letting the table grow would
have an adverse affect on performance for this index, so archiving a
partition off would make sense.
Cheers
Tony
"jaromir nemec" <jaromir@xxxxxxxxxxxx>
Sent by: oracle-l-bounce@xxxxxxxxxxxxx
02/06/2005 09:29 PM
Please respond to
jaromir@xxxxxxxxxxxx
To
<oracle-l@xxxxxxxxxxxxx>
cc
Subject
Re: Partitioning problems - Oracle 8.1.7.4
> Why do you have a separate "archive" table at all?
exactly; it's possible good enough to have only an archive (e.g. read
only)
tablespace.
Archive *table* could be appropriate if you keep only selected columns of
the original table or only some aggregated data.
Jaromir
http://www.db-nemec.com
----- Original Message -----
From: "Tim Gorman" <tim@xxxxxxxxx>
To: <Tony.Adolph@xxxxxx>; <oracle-l@xxxxxxxxxxxxx>
Cc: <Maxim.Demenko@xxxxxx>; <Peter.Trischberger@xxxxxx>; "Tony Adolph"
<t_adolph@xxxxxxxxxxx>; <tony.adolph@xxxxxxxxxx>
Sent: Saturday, February 05, 2005 6:36 PM
Subject: Re: Partitioning problems - Oracle 8.1.7.4
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
