Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2007
    Posts
    1

    Unanswered: displaying tables and users

    first thing...
    how do i display all tables in a database under a certain tablespace?
    i know its select * from dba_tables but then how do i specify the certain tablespace?

    second...
    how do i display all users in the database? again i know its select * from dba_users but how do i specify a tablespace?
    thanks for your help in advance!

  2. #2
    Join Date
    Nov 2007
    Location
    Connecticut
    Posts
    40
    select segment_name from dba_extents where segment_type = 'TABLE' and table_name = 'your table name' and tablespace_name = 'your ts name'

  3. #3
    Join Date
    Nov 2007
    Location
    Connecticut
    Posts
    40

    2nd part

    select username, default_tablespace from dba_users;

Posting Permissions

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