DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Subpartitioning

  1. #1
    Join Date
    Nov 2001
    Posts
    118

    Subpartitioning

    Hi Everyone,

    I've created some tables and indexes and partitioned and subpartitioned them.

    The Enterprise Manager doesn't show me whether this was successfull or not.

    Does anyone have a script querying the database, showing if the partitioned tables and indexes are actually in the assigned tablespaces?

    Thanks
    Peer

  2. #2
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    check PARTITIONED column in DBA_TABLES and DBA_INDEXES.
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

  3. #3
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    select partition_name,tablespace_name from dba_tab_partitions
    where table_name = 'MY_TABLE';

    Construct similar queries for dba_tab_subpartitions, dba_ind_partitions, dba_ind_subpartitions.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  4. #4
    Join Date
    Nov 2001
    Posts
    118
    Thanks, Guys,
    That was exactly what I needed.
    Bye
    Peer

Posting Permissions

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


Click Here to Expand Forum to Full Width