Administration

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 […]
DDL

You Cannot Resize a DataFile in “ALTER TABLESPACE” Except …

Posted on
According to SQL syntax of Oracle database, you can’t resize the data files by using ALTER TABLESPACE except the tablespace was created as BIGFILE, but we know most of tablespaces are created as SMALLFILE. So if you need to resize a normal data file, you’d better to use ALTER DATABASE. SQL> alter database datafile ‘/oracle/oradata/user01.dbf’ […]