Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> newbie q: thanks

newbie q: thanks

From: Vince Laurent <vlaurent_at_NOSPAM.networkusa.net>
Date: Mon, 11 Nov 2002 10:31:54 -0600
Message-ID: <bqmvsukn1sua5supm6msoc7nrrhnq5321i@4ax.com>


Thanks for all the replies.

BTW, we are running 8.1.7.3 on HP-UX 11.0

On Fri, 08 Nov 2002 15:17:27 -0600, Vince Laurent <vlaurent_at_NOSPAM.networkusa.net> 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?
Received on Mon Nov 11 2002 - 10:31:54 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US