Database Administration (MOSC)

MOSC Banner

Why the size of a table growing very fast although the records is growing normal after alter table.

edited Dec 24, 2009 4:53AM in Database Administration (MOSC) 9 commentsAnswered
Dear DBA master,

Could you please help me, I have an issue with the growing of space usage  for a table after performing reorganize the table with the following command:

alter table table_name move tablespace new_tablespace;
alter index theIndexOfThe_table_name rebuild online nologging;
My questions are:

1. Why the size of a table growing very fast although the records is growing normal after alter table.

2. How to solve this issue?

Thank you in advance.

Emal

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