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 -> Re: system database file

Re: system database file

From: Mike Hately <mike.hately_at_virgin.net>
Date: 2000/05/26
Message-ID: <8gkd9j$l8o$1@lure.pipex.net>#1/1 






Christopher,



select owner, segment_name, segment_type, bytes/1024 K
from dba_segments


where tablespace_name='SYSTEM';



Mike Hately


<christopher.lewis_at_ac.com> wrote in message
news:8gk6dj$ti2$1_at_nnrp1.deja.com...


> Hi there - does anyone know how to view which objects are stored in the

> system datafile (i.e. system01.dbf)?  Thanks.

>

>

> Sent via Deja.com http://www.deja.com/

> Before you buy.

Received on Fri May 26 2000 - 00:00:00 CDT












Original text of this message













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