Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Posts
    5

    Unanswered: Show tables that belong to a certain schema

    Hey everyone,

    I'm new to Oracle. I have an Oracle 8 db. When logged in as system, how can I show all tables that belong to a certain schema?

    Thanks
    -Travis

  2. #2
    Join Date
    Apr 2003
    Location
    NY
    Posts
    208

    Re: Show tables that belong to a certain schema

    Select Table_Name
    From All_Tables
    Where Owner = 'SCHEMA_NAME';

Posting Permissions

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