Re: tablespace question

From: Joel Garry <joelga_at_pebble.org>
Date: Tue, 21 Jul 1998 17:22:46 GMT
Message-Id: <slrn6r9jlr.gqk.joelga@pebble.org>

On Fri, 17 Jul 1998 14:39:13 -0700, J. G. Dutcher <jdutcher_at_ridgenet.net> wrote:
>I was checking my freespace (using the recommended query in the admin
>guide) when I noticed that one of my tablespaces did not show up in the
>freespace query. Does this mean that tablespace has no freespace or that
>I have a much more serious problem?

Try select * from dba_tablespaces; and select * from v$datafile; to be sure.

[comp.databases.oracle removed from newsgroups line]

jg
--
These opinions are my own and not necessarily those of Information Quest or Pebble In The Sky http://www.informationquest.com mailto:jgarry@nospameiq.com http://ourworld.compuserve.com/homepages/joel_garry Remove nospam to reply. mailto:joel_garry_at_compuserve.nospam.com "See your DBA?" I AM the @#%*& DBA! Received on Tue Jul 21 1998 - 12:22:46 CDT