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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
