Results 1 to 2 of 2
  1. #1
    Join Date
    May 2011
    Posts
    3

    Red face Unanswered: how can i find out table space in partition environment

    my question is ......? i have one tablespace in a partition db environment,,i want to find out tablespace belongs to which db patition and partition number and to list out the tables in that tablespace,,,,,,,?

    please help me out i am new to db

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    syscat.tablespaces and syscat.tables

    Andy

Posting Permissions

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