8i Index question

From: Ron Rogers <RROGERS_at_galottery.org>
Date: Tue, 04 Dec 2001 11:26:47 -0800
Message-ID: <F001.003D4DCF.20011204105517@fatcity.com>

List,
 I have created tables using partioning that is ranged by the "saledate" column. second column in the table. The partitions contain data by year; 1993,1994,etc. ex:
CREATE TABLE GLCOWSR (

RETNBR          NUMBER(16)      ,
 SALEDATE               DATE            ,
GAMECODE                            NUMBER(16),

 ....
PARTITION BY RANGE(SALEDATE)
(PARTITION OWSRD93 VALUES LESS THAN ('01-01-1994')
TABLESPACE OWSR_DATA_93,
PARTITION OWSRD94 VALUES LESS THAN ('01-01-1995') TABLESPACE OWSR_DATA_94,
.....
I have created indexes on the tables using the (RETNBR,SALEDATE,GAMECODE) as primary key index and a second index using the SALEDATE as a non-unique index. Ex:
ALTER TABLE GLCOWSR

        ADD CONSTRAINT GLCOWSR_PK 
        PRIMARY KEY  (RETNBR, SALEDATE, GAMECODE )
        USING INDEX     

local
(partition owsr93 tablespace owsr_indx_93
storage (initial 2 M next 2 M pctincrease 0), partition owsr94 tablespace owsr_indx_94 storage (initial 2 M next 2 M pctincrease 0), ...

CREATE INDEX GLCOWSR_SALEDATE_NX ON GLCOWSR         (SALEDATE )
local
(partition owsr93 tablespace owsr_indx_93
storage (initial 2 M next 2 M pctincrease 0), partition owsr94 tablespace owsr_indx_94 storage (initial 2 M next 2 M pctincrease 0), ...
There is not a need to change the data in the tables and I need to save backup time and tape space. I made the tablespaces OWSR_DATA_93, OWSR_INDX_93 READ ONLY and took a cold backup of the entire database. Now I only need to backup the tablespaces that relate to the year 2001 and MAXVALUE.
The question I now have is: When I query the DBA_INDEXES table the STATUS shows N/A for the indexes that have some of the tablespaces in the READ ONLY mode and VALID for all other tablespaces. Are my indexes still good? what does N/A mean? I can't find any reference to the index status in my books. Thanks,
Ron
ROR mª¿ªm

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ron Rogers
  INET: RROGERS_at_galottery.org

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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 Tue Dec 04 2001 - 13:26:47 CST