DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Oracle 7.3.4 & file autoextend

  1. #1
    Join Date
    Sep 2000
    Posts
    64
    Hi,

    In Oracle 8.x.x, we can see if the tablespace could auto-increase using the view : DBA_DATA_FILES (AUTOEXTENSIBLE column). What about Oracle 7.3.4 (I am working on some Oracle 7.3.4 BDs and I would like to now if FILE AUTO ENTEND is ON or OFF...).

    Thanks

    Sofiane
    Sofiane

  2. #2
    Join Date
    Feb 2001
    Posts
    123
    Check the sys.filext$ table

    HTH,
    David.

  3. #3
    Join Date
    Sep 2000
    Posts
    64
    Hi,

    I tried with sys.filext$ :

    SQL> desc sys.filext$
    Object does not exist.


    Any idea...

    Thanks

    Sofiane
    Sofiane

  4. #4
    Join Date
    Feb 2001
    Posts
    123
    Quote from the Managing Data Files section of the 7.3.4 Server Administrators Guide:

    Setting your datafiles to extend automatically results in the following:


    reduces the need for immediate intervention when a tablespace runs out of space

    ensures applications will not halt because of failures to allocate extents

    creates FILEXT$, which contains information about the autoextend characteristics of a datafile

    Note: FILEXT$ is not created with the data dictionary scripts, so there is no easy way to create database views on it. Thus, catalog scripts will be unsuccessful if you attempt to create a database view on FILEXT$. FILEXT$ is the only place you can query where datafiles have autoextend turned on, and the current settings of their parameter values.

    --End

    My guess is that the files are not set to autoextend - assuming that you described the table from a user with access to objects in the SYS schema.

  5. #5
    Join Date
    Sep 2000
    Posts
    64
    Thanks Dave_A

    Sofiane
    Sofiane

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width