We are running Oracle 7.3.4.5.0 on an IBM/AIX RISC System/6000: Version 2.3.4.0.0.
I know there is SQL that allows setting a data file to auto extend. I am trying to find out where in the data dictionary you can find out whether a data file is set to auto-extend or not. In later versions of Oracle (8, 8i, 9i) there is an autoextensible column in dba_data_files that provides this information. However, this column does not exist on Oracle 7.3.4:
SQL> desc dba_data_files Name Null? Type ------------------------------- -------- ---- FILE_NAME VARCHAR2(257) FILE_ID NUMBER TABLESPACE_NAME VARCHAR2(30) BYTES NUMBER BLOCKS NUMBER STATUS VARCHAR2(9)
SQL>
Can anybody tell me how I can determine (from the data dictionary, not by experimenting) whether an Oracle 7.3.4 data file is set to auto-extend?
Thank-you,
SB |
- RE: Autoextend on Oracle 7.3.4.5.0 Sam Bootsma
- RE: Autoextend on Oracle 7.3.4.5.0 Pete Sharman
- Re: Autoextend on Oracle 7.3.4.5.0 Charlie_Mengler
- Re: Autoextend on Oracle 7.3.4.5.0 Jared . Still
- Re: Autoextend on Oracle 7.3.4.5.0 Rachel Carmichael
- Re: Autoextend on Oracle 7.3.4.5.0 Chaim . Katz
- RE: Autoextend on Oracle 7.3.4.5.0 Jacques Kilchoer
- RE: Autoextend on Oracle 7.3.4.5.0 Jacques Kilchoer
- Re: Autoextend on Oracle 7.3.4.5.0 Jared . Still
- RE: Autoextend on Oracle 7.3.4.5.0 Rachel Carmichael
- Re: Autoextend on Oracle 7.3.4.5.0 Rachel Carmichael