AutoExtend status
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: AutoExtend status

  1. #1
    Join Date
    Mar 2001
    Posts
    26
    Hello,

    How can I view in Oracle 7 whether I have autoextend on for a particular tablespace/datafile? I would have thought DBA_TABLESPACES or DBA_DATA_FILES would have given the status. I don't see it in storage manager either.

    Thanks.

  2. #2
    Good reason for that - Autoextend is an Oracle 8+ feature :-)


    Oracle 8.1.7 - Desc dba_data_files

  3. #3
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Hmm, Oracle 7? In 8i, its the AUTOEXTENSIBLE column in dba_data_files.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  4. #4
    Join Date
    Nov 2000
    Posts
    344
    In 7.3, you need to select from sys.filext$ and
    outer-join it to dba_data_files.

    John Dorlon
    www.ezsql.net
    john@ezsql.net

  5. #5
    Join Date
    Jan 2001
    Posts
    3,134
    OEM Storage manager would help.
    Is it considered sacrilege to mention GUI tools in this forum?
    MH

  6. #6
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    I may be showing my complete ignorance about OEM, but does it manage 7.3 databases?
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  7. #7
    Join Date
    Mar 2001
    Posts
    26
    Thanks for the help,

    FILEXT$ appears to be what I was looking for. Does anyone know if the MAXEXTEND column is the maxsize in bytes?... or is it kb's?

    Thanks again.


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