Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2004
    Posts
    38

    Unanswered: view a table in the tablespace

    Hi All,

    after I created a table in a tablespace,
    what is the command to view the table?

    Regards,
    Frenk

  2. #2
    Join Date
    Feb 2004
    Location
    Germany
    Posts
    136
    Try this:


    select * from ALL_ALL_TABLES
    where OWNER = 'yourNameOfTablespace';


    Good luck!
    Regards,
    Julia

  3. #3
    Join Date
    Feb 2004
    Location
    Germany
    Posts
    136
    Sorry, it's:


    select * from ALL_ALL_TABLES
    where TABLESPACE_NAME = '...';
    Regards,
    Julia

Posting Permissions

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