OraFAQ Forum: Server Administration » alter database datafile file

Home » RDBMS Server » Server Administration » alter database datafile file_id offline (oracle , 10g, windows xp)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

alter database datafile file_id offline [message #537582]

Thu, 29 December 2011 08:47

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

Re: alter database datafile file_id offline [message #537583 is a reply to message #537582]

Thu, 29 December 2011 09:33

John Watson
Messages: 8929
Registered: January 2010
Location: Global Village

Senior Member

Quote:

can u tell me how to solve the problem ?

You can solve the problem by not trying to invent your own syntax. I think you are trying to apply the offline/online commands for tablespaces to datafiles.

Report message to a moderator

Re: alter database datafile file_id offline [message #537584 is a reply to message #537582]

Thu, 29 December 2011 10:24

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" button to verify.
Also always post your Oracle version, with 4 decimals.

Use SQL*Plus and copy and paste your session, the WHOLE session.

SQL statements are described in Database SQL Reference.
What is not in this manual is invalid.

Regards
Michel

Report message to a moderator