Database Administration (MOSC)

MOSC Banner

alter table table_name move new_tablespace without storage parameter, will the table use its origina

edited Jul 14, 2009 4:19PM in Database Administration (MOSC) 2 commentsAnswered
 Hi,
As the subject states, will the original storage parameter reserved when a table is moved using the above sql? since this is one way to reorganize tablespaces, I wonder whether the initial extents is going to be based on current table size?  I don't seems to have a good environment to test this.

Thanks.
Yinhai

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