skip to main | skip to sidebar

Sam's Oracle BLOG

Nov 27, 2007

oracle managed files

Refer to the following link for further information.

http://download.oracle.com/docs/cd/B14117_01/server.101/b10739/omf.htm

To add temp files, do the following:

alter system set db_create_file_dest='...' scope = both;
create temporary tablespace temp_01 tempfile size 1000m;



Posted by Sam
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: database
Newer Post Older Post Home

My Blog List

  • Oracle Scratchpad
    Pagination Cost – 2
    2 months ago
  • The Momen Blog
    Oracle Database In-Memory Advisor Released
    10 years ago
  • The Tom Kyte Blog
    Upcoming Events...
    11 years ago

www.xobni.com

Xobni outlook add-in for your inbox

Archive

  • ►  2012 (1)
    • ►  Mar (1)
  • ►  2011 (13)
    • ►  Nov (5)
    • ►  Aug (3)
    • ►  May (3)
    • ►  Feb (2)
  • ►  2010 (7)
    • ►  Nov (1)
    • ►  Sep (2)
    • ►  Jun (2)
    • ►  Apr (1)
    • ►  Feb (1)
  • ►  2009 (17)
    • ►  Dec (2)
    • ►  Oct (5)
    • ►  Jul (3)
    • ►  May (3)
    • ►  Apr (1)
    • ►  Mar (2)
    • ►  Jan (1)
  • ►  2008 (44)
    • ►  Dec (5)
    • ►  Nov (1)
    • ►  Oct (1)
    • ►  Sep (20)
    • ►  Aug (17)
  • ▼  2007 (21)
    • ►  Dec (4)
    • ▼  Nov (6)
      • trunc function
      • Rename Tablespace
      • oracle managed files
      • Renaming ORACLE datafiles
      • Finding the time of the last transaction
      • ORA-1031
    • ►  Oct (7)
    • ►  Sep (4)