Home » RDBMS Server » Server Administration » Segment shirnk (Oracle;10.20.3; AIX)
Segment shirnk [message #377274] Mon, 22 December 2008 03:33 Go to next message
rumman
Messages: 48
Registered: June 2007
Location: Bangladesh
Member
Is it possible to execute shrink space when the production database is online?
Will it cause any signifacant overhead?
Re: Segment shirnk [message #377278 is a reply to message #377274] Mon, 22 December 2008 03:42 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
The "ALTER TABLE SHRINK SPACE" must lock the table at some stage. So, you might get away with it, but I wouldn't try it on a busy database.
Re: Segment shirnk [message #377515 is a reply to message #377274] Tue, 23 December 2008 05:22 Go to previous message
samg4ug
Messages: 33
Registered: July 2007
Location: India
Member
Hi,

Before shrinking the tablespace please visit metalink.
One patch sometime is recomended to be applied before shrinking.

Or you may be in great difficulties.Once I faced very bitter experience with 3 days prod data loss.
Regards,
Sam G
Previous Topic: Table not showing dba_tab_modifications(10g)
Next Topic: Redo log information
Goto Forum:
  


Current Time: Sat Dec 10 04:58:50 CST 2016

Total time taken to generate the page: 0.08438 seconds