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
Messages: 48
Registered: June 2007
Location: Bangladesh
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
Messages: 33
Registered: July 2007
Location: India

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.
Sam G
Previous Topic: Table not showing dba_tab_modifications(10g)
Next Topic: Redo log information
Goto Forum:

Current Time: Fri Oct 21 17:47:38 CDT 2016

Total time taken to generate the page: 0.22519 seconds