newbie q: DBMS_SPACE_ADMIN package

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 Fri Nov 08 2002 - 15:17:27 CST