Path: news.easynews.com!newsfeed1.easynews.com!easynews.com!easynews!newsfeed.news2me.com!newsfeed-west.nntpserver.com!hub1.meganetnews.com!nntpserver.com!sjc-peer.news.verio.net!news.verio.net!dfw-read.news.verio.net.POSTED!not-for-mail
From: Vince Laurent <vlaurent@NOSPAM.networkusa.net>
Newsgroups: comp.databases.oracle.server
Subject: newbie q: thanks
Message-ID: <bqmvsukn1sua5supm6msoc7nrrhnq5321i@4ax.com>
References: <nbaosu8kb72spcbk0r4nbe4quaoinl80gb@4ax.com>
X-Newsreader: Forte Agent 1.8/32.548
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 21
Date: Mon, 11 Nov 2002 10:31:54 -0600
NNTP-Posting-Host: 199.217.149.3
X-Complaints-To: abuse@verio.net
X-Trace: dfw-read.news.verio.net 1037032444 199.217.149.3 (Mon, 11 Nov 2002 16:34:04 GMT)
NNTP-Posting-Date: Mon, 11 Nov 2002 16:34:04 GMT
Organization: NTT/Verio
Xref: newsfeed1.easynews.com comp.databases.oracle.server:166561
X-Received-Date: Mon, 11 Nov 2002 09:31:51 MST (news.easynews.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@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?