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

Thread: Non-partition objects

  1. #1
    Join Date
    Jan 2008
    Posts
    3

    Non-partition objects

    Hi
    1.How can we find the non-partitioned objects in tablespaces and move these to another tablespace in oracle 10g.
    2.How to find partition objects which are active in tablespaces.

    Thanks in advance
    mkr
    Last edited by manojmkr; 01-02-2008 at 07:56 AM.

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    neither of those questions makes sense

  3. #3
    Join Date
    Jan 2008
    Posts
    3
    hi davey
    y does'nt make sense, iam asking how can we find non-partitioned objects in tablespace & active partitioned objects.

  4. #4
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    take dave's advice.. restructure your questions.. and most importantly know what your asking..
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  5. #5
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,555
    I'll give it a try...

    You can query dba_tab_partitions and dba_ind_partitions to find out which tables and indexes are partitioned, also in which tablespace each partition is sitting.

    You can query dba_tables and dba_indexes minus select distinct from dba_tab_partitions and dba_ind_partitions to find out which tables and indexes are not partitioned, also in which tablespace the non-partitioned objects are sitting.
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  6. #6
    Join Date
    Jan 2008
    Posts
    3
    Thanks PAVB

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