Oracle Database Administration

Autoextend on script

spool autoext.sql
 
select
   'alter database datafile '||
   file_name||
   ' '||
   ' autoextend on;'
from
   dba_data_files;
 
@autoext
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Pageviews

Blog Archive

  • ►  2023 (2)
    • ►  Dec (2)
  • ►  2014 (1)
    • ►  Feb (1)
  • ►  2013 (8)
    • ►  Aug (1)
    • ►  Jun (7)
  • ►  2012 (17)
    • ►  Dec (16)
    • ►  Jan (1)
  • ►  2011 (9)
    • ►  Sep (5)
    • ►  Feb (1)
    • ►  Jan (3)
  • ▼  2010 (26)
    • ►  Dec (4)
    • ▼  Nov (22)
      • Oracle table to html file & Excel
      • Oracle import from 10.2.0.2.0 to 10.1.0.1.0
      • Silent DBCA
      • Changing Character set of DB - CSSCAN
      • Tablespace Free Sapce
      • Crontab - Quick reference
      • Script to Move Tables and Indexes to another Table...
      • Oracle Background Process
      • Deadlocks
      • AUTOMATED HOT BACK UP IN LINUX
      • Remote Diagnostic Agent (RDA)
      • Interim patches
      • Flash Recovery Area Full
      • Autoextend on script
      • User Sessions
      • Fragmentation
      • Active Recovery Desktop
      • Create tablespace Script
      • OS bit info.
      • Oracle BIT info.
      • Controlfile creation script
      • Datagaurd
Simple theme. Powered by Blogger.