How to Move Oracle Database

Posted on
Actually, this topic “How to Move Oracle Database” follows my previous post: How to Move ORACLE HOME. But I think it can be used in any moving operations. Generally speaking, this post will include the following subtle topics: How to move spfile How to move control files How to move database files How to move […]
Temp File

How to Take Temporary Tablespaces Offline

Posted on
Basically, you can’t take temporary tablespaces offline.SQL> alter tablespace temp offline;alter tablespace temp offline*ERROR at line 1:ORA-03217: invalid option for alter of TEMPORARY TABLESPACEInstead, you should take each temp file offline. SQL> alter database tempfile ‘/u01/app/oracle/oradata/ORCL/temp01.dbf’ offline;Database altered.If the temporary tablespace is not the default one. You can take all temp files offline in the […]