Re: How to get partition info on a table?

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Tue, 2 Nov 2004 06:48:36 +0100
Message-ID: <41871fea$0$302$636a15ce@news.free.fr>

"Sumitro Samaddar" <samaddar_at_hotmail.com> a écrit dans le message de news:c34d3f6a.0411011753.4bf2ceb0_at_posting.google.com...
> We have a multi-threaded application that sources data from a given
> Oracle table. We want to create multiple threads such that each thread
> gets rows from one or more partitions and does some processing on
> them. How do we detect how many partitions are defined for that table
> and what are their names? Essentially, we want to be able to generate
> SQL queries (SELECT statements) to fetch rows from specific
> partition(s).
>
> Thanks.
> -Sumitro

user/all/dba_tab_partitions
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96536/ch2147.htm#1303158

Btw, Oracle is able to parallel queries across partitions. If your processing requests only SQL, use this feature instead of multithreaded application.

-- 
Regards
Michel Cadot

Received on Mon Nov 01 2004 - 23:48:36 CST