alter database datafile next PDF Print E-mail
6/13/12

Oracle database FAQ - Oracle FAQ
ALTER DATABASE DATAFILE 1 AUTOEXTEND ON NEXT 1M MAXSIZE UNLIMITED; .
http://www.orafaq.com/wiki/Oracle_database_FAQ

Tablespace and Datafiles in Oracle Database : Back to Basics ...
Feb 8, 2008 . ALTER DATABASE DATAFILE '/u01/oracle/oradata/data02.dbf' AUTOEXTEND ON NEXT 30M MAXSIZE 1200M;. which means datafile .
http://onlineappsdba.com/index.php/2008/02/08/tablespace-and-datafiles-in-oracle-database-back-to-basics/


The Summary to the Opinion states: 

Alter - DBSTAR.com
ALTER DATAFILE -- see ALTER DATABASE DATAFILE -- add a data file - see . IX1 STORAGE ( NEXT 2M PCTINCREASE 20); -- rebuild an index alter index .
http://www.dbstar.com/dispref.asp?ref_name=alters.sql


Altering Datafile Availability
Go to previous page. Previous · Go to next page. Next . To bring an individual datafile online, issue the ALTER DATABASE statement and include the .
http://docs.oracle.com/cd/E11882_01/server.112/e25494/dfiles004.htm

ALTER DATABASE File and Filegroup Options (Transact-SQL)
ALTER DATABASE Database Mirroring (Transact-SQL) . To move a data file or log file to a new location, specify the current logical file name in the NAME .
http://msdn.microsoft.com/en-us/library/bb522469.aspx


Move datafile to different location - Oracle FAQ
Jun 9, 2012 . Take the datafile offline with the "ALTER DATABASE DATAFILE '/old/location' OFFLINE;" command. Copy or move the datafile to its new .
http://www.orafaq.com/wiki/Move_datafile_to_different_location

Oracle Data File Temp Tempfile Datafile
Resize An Existing Datafile, ALTER DATABASE DATAFILE .
http://psoug.org/reference/datafiles.html


Moving ASM Database Files from one ... - iDevelopment.info
Jan 17, 2012 . SQL> ALTER DATABASE DATAFILE '+TESTDB_DATA2/testdb/datafile/app_data .256.598127837' OFFLINE; Database altered.
http://www.idevelopment.info/data/Oracle/DBA_tips/Automatic_Storage_Management/ASM_36.shtml


Datafile Resizing Tips
Alter database name datafile 'file_name' resize size;. Where name is the name of the database, file_name is the name of the file and size is the new size to make .
http://www.dba-oracle.com/art_dbazine_weeg_datafile_resizing_tips.htm