| Segment shirnk [message #377274] |
Mon, 22 December 2008 03:33  |
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  |
Frank Naude
Messages: 4580
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 |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
