Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2003
    Posts
    4

    Question Unanswered: list all tablespaces

    Hi,

    How to list all tablespaces in sqlplus ?

    Thanks!

    peter

  2. #2
    Join Date
    Mar 2002
    Location
    Ireland
    Posts
    181
    SQL> select tablespace_name from dba_tablespaces;

    Rgs,
    Breen.

  3. #3
    Join Date
    Sep 2003
    Location
    Delhi
    Posts
    15
    U can query the column tablespace_name from dba_tablespaces or user_tablespaces....

    bye,
    pinaki

Posting Permissions

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