Tag: datafile

Move datafile to different location

beheerder • 8 december 2015 • Leave a comment

http://www.orafaq.com/wiki/Move_datafile_to_different_location Database is in ARCHIVELOG mode Take the datafile offline with the "ALTER DATABASE DATAFILE '/old/location' OFFLINE;" command. Copy or...

Renaming or Moving Oracle Files

beheerder • 3 december 2015 • Leave a comment

https://oracle-base.com/articles/misc/renaming-or-moving-oracle-filesRenaming or Moving Oracle Files This article presents a brief explanation of how assorted Oracle files can be renamed or...

(temporary) tablespaces, undo tablespace, default tablespace, create shrink tablespace

beheerder • 25 november 2015 • Leave a comment

http://www.orafaq.com/node/2 Default Temporary Tablespaces: In Oracle 9i and above, one can define a Default Temporary Tablespace at database creation time,...