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

Thread: AutoExtend status

  1. 08-10-2001, 09:59 AM #1
    rygi
    rygi is offline Junior Member
    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.
    Reply With Quote Reply With Quote
  2. 08-10-2001, 10:03 AM #2
    bmycroft
    bmycroft is offline Member
    Join Date
    Sep 2000
    Posts
    193
    Good reason for that - Autoextend is an Oracle 8+ feature :-)


    Oracle 8.1.7 - Desc dba_data_files
    Reply With Quote Reply With Quote
  3. 08-10-2001, 10:03 AM #3
    marist89's Avatar
    marist89
    marist89 is offline Super-Genius
    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
    Reply With Quote Reply With Quote
  4. 08-10-2001, 10:08 AM #4
    jdorlon
    jdorlon is offline Senior Member
    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
    Reply With Quote Reply With Quote
  5. 08-10-2001, 10:35 AM #5
    Mr.Hanky's Avatar
    Mr.Hanky
    Mr.Hanky is offline X-Mas poo
    Join Date
    Jan 2001
    Posts
    3,134
    OEM Storage manager would help.
    Is it considered sacrilege to mention GUI tools in this forum?
    MH
    Reply With Quote Reply With Quote
  6. 08-10-2001, 11:34 AM #6
    marist89's Avatar
    marist89
    marist89 is offline Super-Genius
    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
    Reply With Quote Reply With Quote
  7. 08-10-2001, 12:08 PM #7
    rygi
    rygi is offline Junior Member
    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.

    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width