Re: newbie q: DBMS_SPACE

From: s.kapitza <skapitza_at_volcanomail.com>
Date: 9 Nov 2002 12:10:59 -0800
Message-ID: <26703915.0211091210.21e0acfc@posting.google.com>

Hi Vince,

maybe looking up Objects in priv Views isn't a good Idear.

SQL> r
  1 SELECT table_name, grantee
  2 FROM all_tab_privs
  3 WHERE grantor='SYS' and privilege='EXECUTE'   4* and table_name like 'DBMS_SPACE%'

TABLE_NAME                     GRANTEE
------------------------------ ------------------------------
DBMS_SPACE                     PUBLIC

SQL> select distinct name from dba_source where name like 'DBMS_SPACE%';

NAME

DBMS_SPACE
DBMS_SPACE_ADMIN SQL> hth.

s.kapitza
Vince Laurent <vlaurent_at_NOSPAM.networkusa.net> wrote in message news:<nbaosu8kb72spcbk0r4nbe4quaoinl80gb_at_4ax.com>...
> According the the documentation: "DBMS_SPACE_ADMIN is a built-in
> PL/SQL package that Oracle provides to help you maintain the integrity
> of locally managed tablespaces."
>
> I ran a query:
> SQL> SELECT table_name, grantee
> 2 FROM all_tab_privs
> 3 WHERE grantor='SYS' and privilege='EXECUTE'
> 4 ORDER BY table_name;
>
> to see what packages were installed. This on was not. Does it NOT
> install by default? What if I don't have locally managed tablespaces,
> would I need it?
>
> Thanks!
> Vince
Received on Sat Nov 09 2002 - 14:10:59 CST

Re: newbie q: DBMS_SPACE_ADMIN package