TOAD - Tablespaces
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: TOAD - Tablespaces

Hybrid View

  1. #1
    Join Date
    Jun 2001
    Posts
    88
    Hi Guys

    When I am trying to open Tablespaces, from
    View > Tablespaces, I m getting following error
    This function requires access to dba_free_space,
    dba_data_files, Dba_tablespaces fragmentation requires.

    What is the problem? What I need to do to solve this problem
    Thanks

    Akash

  2. #2
    Join Date
    Apr 2002
    Location
    Germany.Laudenbach
    Posts
    448
    Hello;

    Your current user needs access to these views.

    GRANT SELECT ON :Object: to CurrentUser;
    OR
    GRANT SELECT ANY TABLE TO ...

    With 9i you need additionally a grant for viewing catalog objects;
    GRANT SELECT CATALOG -- ore something like this, view the doc please

    Orca


  3. #3
    Join Date
    Feb 2002
    Posts
    70
    Hi,

    Check out whether you are log in as System. If you login as different user without sufficient privileges to view the SYS tables, it will throw you errors.

    I hope this answer your problem.

    Thanks,
    ________________
    ShanDJ

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