alter database datafile file_id offline [message #537582] |
Thu, 29 December 2011 08:47 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/166452.jpg) |
lonion
Messages: 97 Registered: August 2011 Location: shenzhen,China
|
Member |
|
|
hi , all .
when i make a datafile offline,can i add the following option:
normal or immediate?
such as like here:
SQL> ALTER DATABASE DATAFILE 5 OFFLINE NORMAL;
OR
SQL> ALTER DATABASE DATAFILE 5 ONLINE IMMEDIATE;
when i try a test ,it occurs an error:ORA-00933.
can u tell me how to solve the problem ?
thank u .
[Updated on: Thu, 29 December 2011 08:50] Report message to a moderator
|
|
|
|
|
|
|