Results 1 to 2 of 2

Thread: Accessing multiple partition

  1. #1
    Join Date
    Mar 2005
    Location
    Madagascar
    Posts
    16

    Accessing multiple partition

    I have a table xyz with partitions for the last 2
    years. If I want to query multiple partitions with a
    single query what do I need to do. I tried,

    select bla bla bla from xyz partition(APR2006),
    partition(MAY2006);

    and

    select bla bla bla from xyz partition(APR2006,MAY2006)

    but this did not work
    Can what I am trying to do be done?

  2. #2
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    Do you need to select only from few partions not all?

    If you write your WHERE clause to get records from them then Oracle only goes to those partions such as


    select bla bla bla from xyz
    where partitioncolumnvalue between partition <value1> and <value2>;

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •