Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2005
    Posts
    276

    Unanswered: system table for partitions

    What is the system table where from I can get all the info related to the partitions on a particular table.
    I checked all_tab_partitions, but what I want is
    tablename
    column name
    partition type
    column on which the partition is created
    data in each partition
    and so on....

    Thanks in advance..

  2. #2
    Join Date
    May 2004
    Location
    Dominican Republic
    Posts
    721
    DBA_TAB_PARTITIONS
    DBA_PART_KEY_COLUMNS

    data in each partition ?

Posting Permissions

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