OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » can't offline

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

can't offline [message #238712]

Sat, 19 May 2007 11:06

bksrisai
Messages: 30
Registered: May 2007
Location: hyderabad

Member

why we can't offline a datafile in noarchive mode but we canoffline drop that datafile what is the reason can any explain me

Report message to a moderator

Re: can't offline [message #238715 is a reply to message #238712]

Sat, 19 May 2007 12:00

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

"Offline drop" means you will never use the datafile so Oracle does not care you are in archive log or no archive log mode.
"Offline" needs archive log mode because you need to make a media recovery if you want to put it back online and this can be done only in archive log mode.

Beware that "offline drop" does not drop the file.
In 10g this clause was renamed to a more accurate "offline for drop".

Regards
Michel

Report message to a moderator

Re: can't offline [message #238716 is a reply to message #238715]

Sat, 19 May 2007 12:17

bksrisai
Messages: 30
Registered: May 2007
Location: hyderabad

Member

thank u very much

Report message to a moderator

select * from emp [message #238717 is a reply to message #238716]

Sat, 19 May 2007 12:18

bksrisai
Messages: 30
Registered: May 2007
Location: hyderabad

Member

what happens internally when i give select * from emp

Report message to a moderator

Re: select * from emp [message #238718 is a reply to message #238717]

Sat, 19 May 2007 12:21

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Start a new topic.
Don't use an old one for a new question.

Regards
Michel

Report message to a moderator

Re: can't offline [message #238719 is a reply to message #238712]

Sat, 19 May 2007 12:22

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>what happens internally when i give select * from emp
OK, I give up. What does happen when you "select * from emp"?
Please use CUT & PASTE and post the results back here.

Report message to a moderator

Previous Topic:	Undo space
Next Topic:	select * from emp

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 02 12:29:25 CST 2024