Database Administration (MOSC)

MOSC Banner

Questions related to alter table shrink cascade

edited Jun 8, 2009 1:42AM in Database Administration (MOSC) 4 commentsAnswered
1. Are there any situations where enabling row movement will not be advisable? We have a high transactional OLTP 800 GB database (10.2.0.4 version). I have recently started to administer it and is used by a third party vendor product.

2. How to tell if there are rowid based triggers on a table? I ran compact command on a table in one of the test databases and it right away disabled triggers on that table automatically. Is that normal behavior?

3. While shrink command is running, will there be any effect on performance of the database?

4. If I cancel out of shrink command after say 1 hour, will the work done during that hour be repeated next time I issue the command on the same table again?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center