cannot find othter tablepace in dba_ts_quotas
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: cannot find othter tablepace in dba_ts_quotas

  1. #1
    Join Date
    Feb 2004
    Posts
    9

    cannot find othter tablepace in dba_ts_quotas

    hi all,
    i have a problem
    when i give SQL> SELECT * FROM v$TABLESPACE; it shows all the tablespaces
    TS# NAME INC
    ---------- ------------------------------ ---
    3 CWMLITE YES
    4 DRSYS YES
    5 EXAMPLE YES
    6 INDX YES
    7 ODM YES
    0 SYSTEM YES
    8 TOOLS YES
    1 UNDOTBS1 YES
    9 USERS YES
    10 XDB YES
    2 TEMP YES
    11 rows selected.
    but i cant find the details of the tablespace in dba_ts_quotas why is that
    SQL> select tablespace_name from dba_ts_quotas;
    TABLESPACE_NAME
    ------------------------------
    ODM
    ODM
    CWMLITE
    TOOLS
    EXAMPLE
    EXAMPLE
    EXAMPLE
    EXAMPLE
    EXAMPLE
    EXAMPLE
    EXAMPLE

  2. #2
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    RTM (Ref)
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

Posting Permissions

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


Click Here to Expand Forum to Full Width