Home » RDBMS Server » Server Administration » can't offline
can't offline [message #238712] Sat, 19 May 2007 11:06 Go to next message
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
Re: can't offline [message #238715 is a reply to message #238712] Sat, 19 May 2007 12:00 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
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

Re: can't offline [message #238716 is a reply to message #238715] Sat, 19 May 2007 12:17 Go to previous messageGo to next message
bksrisai
Messages: 30
Registered: May 2007
Location: hyderabad
Member

thank u very much
select * from emp [message #238717 is a reply to message #238716] Sat, 19 May 2007 12:18 Go to previous messageGo to next message
bksrisai
Messages: 30
Registered: May 2007
Location: hyderabad
Member

what happens internally when i give select * from emp
Re: select * from emp [message #238718 is a reply to message #238717] Sat, 19 May 2007 12:21 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Start a new topic.
Don't use an old one for a new question.

Regards
Michel
Re: can't offline [message #238719 is a reply to message #238712] Sat, 19 May 2007 12:22 Go to previous message
BlackSwan
Messages: 25036
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.
Previous Topic: Undo space
Next Topic: select * from emp
Goto Forum:
  


Current Time: Sun Dec 04 18:49:00 CST 2016

Total time taken to generate the page: 0.14568 seconds