Re: Problem with partitioning

nitesh wrote:
> Hi all,
>
>
> In my organization, few tables were partitioned recently. But all the
> rows are going to default partition istead of going to the appropriate
> partition. So the appliclation team thinks that something wasn't done
> correctly - rows aren't distributed.
>
> So my task is to investigate why rows are going to default partition.
> I would appreciate if someone can help me out.

Sure. Send a plane ticket and make a reservation for a room at a local hotel: Non-smoking please.

What do you want someone to do? Jut make up answers for you without knowing version, DDL, or how it was done? Ok. But that costs more.

Post the script used to create and load the tables including all relevant DDL.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org