Re: Problems about partition table, thanks.

In article <9kipeq$3vl1_at_imsp212.netvigator.com>, "Jordan" says...
>
>I have created a table which is partitioned into two different tablespace,
>USERS01 & USERS02. However, if USERS02 tablespace is offline or may due to
>some corruption of data file. I can query that table. Can anyone tell me
>what I need to do to view the remain data in USERS01 immediately before data
>file of USERS02 tablespace restored. THANKS...
>
>

If you want to see all of the data in the partition in USERS01 just use the partition extended name in the select:

select * from t PARTITION(name-of-partition-in-users01);

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp