Re: Autoextend on Oracle 7.3.4.5.0
It's possible they were, I never worked in 7.2. However, I have a real, honest-to-goodness hard-bound book of the Oracle7 SQL Reference manual (7.0) and the clause autoexend is not in there. So we've narrowed down the time when autoextend was introduced. Rachel --- Mogens_Nørgaard [EMAIL PROTECTED] wrote: I think they were introduced in 7.2? Mogens Rachel Carmichael wrote: well I was using them in 7.3.4 so ... either I was delusional or they existed :) and I do remember writing about them in some book or other :) --- [EMAIL PROTECTED] wrote: Had no idea they were available in 7.3.4. Rachel Carmichael [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 02/21/2003 10:55 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: Autoextend on Oracle 7.3.4.5.0 sys.filext$ has to be joined to to the dba_data_files view. however, if no tablespace has ever been put into autoextend mode, filext$ won't exist. what I've done in the past to ensure the queries will work is to put a datafile into autoextend mode (this creates filext$), then take it out. filext$ is not dropped once created, even if there are no rows in it. then you can do the join. If a datafile is IN filext$, it is set for autoextend --- Sam Bootsma [EMAIL PROTECTED] wrote: 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 NameNull?Type --- FILE_NAMEVARCHAR2(257) FILE_ID NUMBER TABLESPACE_NAME VARCHAR2(30) BYTESNUMBER 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 __ Do you Yahoo!? Yahoo! Tax Center - forms, calculators, tips, more http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! Tax Center - forms, calculators, tips, more http://taxes.yahoo.com/ __ Do you Yahoo!? Yahoo! Tax Center - forms, calculators, tips, more http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send
RE: Autoextend on Oracle 7.3.4.5.0
Title: Message IIRC, you needed FILE$ or FILEXT$ - something like that anyway (those brain cells are long gone, I'm afraid!) Pete "Controlling developers is like herding cats." Kevin Loney, Oracle DBA Handbook "Oh no, it's not. It's much harder than that!" Bruce Pihlamae, long-term Oracle DBA -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Sam BootsmaSent: Friday, February 21, 2003 7:44 AMTo: Multiple recipients of list ORACLE-LSubject: Autoextend on Oracle 7.3.4.5.0 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
select * from filext$; AFAIK an entry here means this file is now in auto-extend mode. HTH YMMV HAND! Sam Bootsma [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] .on.ca cc: Sent by: Subject: Autoextend on Oracle 7.3.4.5.0 [EMAIL PROTECTED] 02/21/2003 07:44 AM Please respond to ORACLE-L 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 NameNull?Type --- FILE_NAMEVARCHAR2(257) FILE_ID NUMBER TABLESPACE_NAME VARCHAR2(30) BYTESNUMBER 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 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Autoextend on Oracle 7.3.4.5.0
That feature is not available until 8.0 or 8i, forget which. Jared Sam Bootsma [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 02/21/2003 07:44 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Autoextend on Oracle 7.3.4.5.0 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 NameNull?Type --- FILE_NAMEVARCHAR2(257) FILE_ID NUMBER TABLESPACE_NAME VARCHAR2(30) BYTESNUMBER 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 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Autoextend on Oracle 7.3.4.5.0
sys.filext$ has to be joined to to the dba_data_files view. however, if no tablespace has ever been put into autoextend mode, filext$ won't exist. what I've done in the past to ensure the queries will work is to put a datafile into autoextend mode (this creates filext$), then take it out. filext$ is not dropped once created, even if there are no rows in it. then you can do the join. If a datafile is IN filext$, it is set for autoextend --- Sam Bootsma [EMAIL PROTECTED] wrote: 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 NameNull?Type --- FILE_NAMEVARCHAR2(257) FILE_ID NUMBER TABLESPACE_NAME VARCHAR2(30) BYTESNUMBER 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 __ Do you Yahoo!? Yahoo! Tax Center - forms, calculators, tips, more http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Autoextend on Oracle 7.3.4.5.0
Sam, SQL select * 2 from sys.filext$; FILE# MAXEXTENDINC -- -- -- 9 256000 64000 17 256000 64000 The result must be oracle blocks Chaim [EMAIL PROTECTED]@fatcity.com on 02/21/2003 02:09:39 PM Please respond to [EMAIL PROTECTED] Sent by:[EMAIL PROTECTED] To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: That feature is not available until 8.0 or 8i, forget which. Jared Sam Bootsma [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 02/21/2003 07:44 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Autoextend on Oracle 7.3.4.5.0 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 NameNull?Type --- FILE_NAMEVARCHAR2(257) FILE_ID NUMBER TABLESPACE_NAME VARCHAR2(30) BYTESNUMBER 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 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Autoextend on Oracle 7.3.4.5.0
Title: RE: Autoextend on Oracle 7.3.4.5.0 Actually autoextend datafiles were available in Oracle 7.3.4. I just checked in the Oracle 7 Server SQL Reference Manual (HTML) that we have here. I do remember though that you wouldn't see the autoextend column unless you applied the right patch or something? My memory is failing me, but it's something to do with a data dictionary table called SYS.FILEXT$. Does table SYS.FILEXT$ have a column in it called INC? If it does then you should be able to create an autoextend datafile. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] That feature is not available until 8.0 or 8i, forget which. Sam Bootsma [EMAIL PROTECTED] 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?
RE: Autoextend on Oracle 7.3.4.5.0
Title: RE: Autoextend on Oracle 7.3.4.5.0 Whoops, my mistake. Just read what Rachel Carmichael said, she had the right answer. -Original Message- From: Jacques Kilchoer Actually autoextend datafiles were available in Oracle 7.3.4. I just checked in the Oracle 7 Server SQL Reference Manual (HTML) that we have here. I do remember though that you wouldn't see the autoextend column unless you applied the right patch or something? My memory is failing me, but it's something to do with a data dictionary table called SYS.FILEXT$. Does table SYS.FILEXT$ have a column in it called INC? If it does then you should be able to create an autoextend datafile.
Re: Autoextend on Oracle 7.3.4.5.0
Had no idea they were available in 7.3.4. Rachel Carmichael [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 02/21/2003 10:55 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: Autoextend on Oracle 7.3.4.5.0 sys.filext$ has to be joined to to the dba_data_files view. however, if no tablespace has ever been put into autoextend mode, filext$ won't exist. what I've done in the past to ensure the queries will work is to put a datafile into autoextend mode (this creates filext$), then take it out. filext$ is not dropped once created, even if there are no rows in it. then you can do the join. If a datafile is IN filext$, it is set for autoextend --- Sam Bootsma [EMAIL PROTECTED] wrote: 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 NameNull?Type --- FILE_NAMEVARCHAR2(257) FILE_ID NUMBER TABLESPACE_NAME VARCHAR2(30) BYTESNUMBER 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 __ Do you Yahoo!? Yahoo! Tax Center - forms, calculators, tips, more http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Autoextend on Oracle 7.3.4.5.0
not a patch, just that sys.filext$ isn't created until at least one datafile has been made autoextensible. Once you do that, it stays around and you can check that table to find out which datafiles can extend. If it's there, it can. sys.filext$ still exists in 9i, I just checked :) --- Jacques Kilchoer [EMAIL PROTECTED] wrote: Actually autoextend datafiles were available in Oracle 7.3.4. I just checked in the Oracle 7 Server SQL Reference Manual (HTML) that we have here. I do remember though that you wouldn't see the autoextend column unless you applied the right patch or something? My memory is failing me, but it's something to do with a data dictionary table called SYS.FILEXT$. Does table SYS.FILEXT$ have a column in it called INC? If it does then you should be able to create an autoextend datafile. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] That feature is not available until 8.0 or 8i, forget which. Sam Bootsma [EMAIL PROTECTED] 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 NameNull?Type --- FILE_NAMEVARCHAR2(257) FILE_ID NUMBER TABLESPACE_NAME VARCHAR2(30) BYTESNUMBER 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? __ Do you Yahoo!? Yahoo! Tax Center - forms, calculators, tips, more http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Autoextend on Oracle 7.3.4.5.0
well I was using them in 7.3.4 so ... either I was delusional or they existed :) and I do remember writing about them in some book or other :) --- [EMAIL PROTECTED] wrote: Had no idea they were available in 7.3.4. Rachel Carmichael [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 02/21/2003 10:55 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: Autoextend on Oracle 7.3.4.5.0 sys.filext$ has to be joined to to the dba_data_files view. however, if no tablespace has ever been put into autoextend mode, filext$ won't exist. what I've done in the past to ensure the queries will work is to put a datafile into autoextend mode (this creates filext$), then take it out. filext$ is not dropped once created, even if there are no rows in it. then you can do the join. If a datafile is IN filext$, it is set for autoextend --- Sam Bootsma [EMAIL PROTECTED] wrote: 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 NameNull?Type --- FILE_NAMEVARCHAR2(257) FILE_ID NUMBER TABLESPACE_NAME VARCHAR2(30) BYTESNUMBER 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 __ Do you Yahoo!? Yahoo! Tax Center - forms, calculators, tips, more http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! Tax Center - forms, calculators, tips, more http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Autoextend on Oracle 7.3.4.5.0
I think they were introduced in 7.2? Mogens Rachel Carmichael wrote: well I was using them in 7.3.4 so ... either I was delusional or they existed :) and I do remember writing about them in some book or other :) --- [EMAIL PROTECTED] wrote: Had no idea they were available in 7.3.4. Rachel Carmichael [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 02/21/2003 10:55 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: Autoextend on Oracle 7.3.4.5.0 sys.filext$ has to be joined to to the dba_data_files view. however, if no tablespace has ever been put into autoextend mode, filext$ won't exist. what I've done in the past to ensure the queries will work is to put a datafile into autoextend mode (this creates filext$), then take it out. filext$ is not dropped once created, even if there are no rows in it. then you can do the join. If a datafile is IN filext$, it is set for autoextend --- Sam Bootsma [EMAIL PROTECTED] wrote: 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 NameNull?Type --- FILE_NAMEVARCHAR2(257) FILE_ID NUMBER TABLESPACE_NAME VARCHAR2(30) BYTESNUMBER 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 __ Do you Yahoo!? Yahoo! Tax Center - forms, calculators, tips, more http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! Tax Center - forms, calculators, tips, more http://taxes.yahoo.com/
