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: V$ Table to Find autoextend information

Re: V$ Table to Find autoextend information

From: INOUE Katsumi <kinoue_at__nospam_jp.oracle.com>
Date: 1997/09/24
Message-ID: <60ae8s$rsa$1@inet16.us.oracle.com>#1/1

In article <34289F9F.41D0DEA4_at_tantalus.com>, Mark Allen <mark_at_tantalus.com> wrote:
> I need to find the table where I can get the information about the
>autoextend
>parameters of a tablespace.

Hello,

for Oracle7 do "select * from filext$;"
for Oracle8 do "select * from dba_data_files;"

-- 
This posting represents the personal opinions of the author. It is not the
official opinion or policy of the author's employer.
Received on Wed Sep 24 1997 - 00:00:00 CDT

Original text of this message

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