Re: newbie q: DBMS_SPACE_ADMIN package

Vince Laurent wrote:

> 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

What version of Oracle?

Search $ORACLE_HOME/rdbms/admin for a script containing it.

Without version information little help is possible.

Daniel Morgan Received on Fri Nov 08 2002 - 17:00:48 CST