Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: AUTOEXTEND question
If filext$ doesn't exist you have no files with AUTOEXTEND enabled.
Regards
Mike Hately
Syltrem <syltrem_at_videotron.ca> wrote in message
news:wjcX4.926$p7.10200_at_wagner.videotron.net...
> Thanks very much!
>
> It raises another question, though. It works fine on the database for
> application A (installed by an application provider) but not for database
B
> (installed by me).
>
> from sys.filext$ a, v$dbfile b
> *
> ERROR at line 4:
> ORA-00942: table or view does not exist
>
>
> Do I need to run some SQL script to get the filext$ table created?
>
> I am running Oracle 7.3.3.6 - and that's right, this version does not
> provide the information in dba_data_files
>
> Michel Cadot <micadot_at_netcourrier.com> wrote in message
> news:8gjec6$rjt$1_at_s2.feed.news.oleane.net...
> > answer embedded.
> >
> > Syltrem <syltrem_at_videotron.ca> a écrit dans le message :
5IaX4.811$p7.7098_at_wagner.videotron.net...
> > > Hello!
> > >
> > > Is there a way to know if a datafile AUTOEXTEND option is ON?
> >
> > You have information on autoextend in sys.filext$ table:
> >
> > v734> select * from sys.filext$;
> >
> > FILE# MAXEXTEND INC
> > ---------- ---------- ----------
> > 1 4194302 5120
> > 2 25600 2560
> > 3 25600 2560
> > 4 4194302 5120
> > 5 4194302 4096
> >
> > 5 rows selected.
> >
> > You can join with v$dbfile to get the name of the
> > file instead of its id:
> >
> > v734> select substr(b.name,1,30) "Filename",
> > 2 nvl(to_char(a.maxextend, 9999999999999), 'AUTOEXTEND OFF')
"Max Extend",
> > 3 nvl(to_char(a.inc, 9999999999999), 'AUTOEXTEND OFF')
"Increment"
> > 4 from sys.filext$ a, v$dbfile b
> > 5 where b.file# = a.file# (+)
> > 6 order by b.name;
> >
> > Filename Max Extend Increment
> > ------------------------------ -------------- --------------
> > C:\ORACLE\ORA1\TS_D0101.ORA 4194302 5120
> > C:\ORACLE\ORA1\TS_I0101.ORA 4194302 4096
> > C:\ORACLE\ORA1\TS_ORACLE01 AUTOEXTEND OFF AUTOEXTEND OFF
> > C:\ORACLE\ORA1\TS_R0101.ORA 25600 2560
> > C:\ORACLE\ORA1\TS_S0101.ORA 4194302 5120
> > C:\ORACLE\ORA1\TS_T0101.ORA 25600 2560
> >
> > 6 rows selected.
> >
> > >
> > > Also, is it possible that even though autoextend is on, I end up
getting
the
> > > message
> > > ORA-1652: unable to extend temp segment by 10070 in tablespace TEMP
> >
> > Maybe your file system or your disk is full
> > or maybe you reached the maxextend of your datafile.
> >
> > >
> > > The fact that the tablespace has grown a lot (I don't yet know what
the
> > > programmers do in there) makes me think that autoextend was on, but
with
> > > this message I don't know anymore, and I can't check to make sure.
> > >
> > > Thanks!
> > >
> >
> > --
> > Have a nice day
> > Michel
> >
> >
> >
> >
>
>
Received on Thu May 25 2000 - 00:00:00 CDT