Database Administration (MOSC)

MOSC Banner

Unable to reorganize a large tablespace

edited Nov 12, 2008 9:33PM in Database Administration (MOSC) 9 comments

Oracle 10.2.0.3

Solaris 10

Sunfire E2900

I'm trying to convert a large tablespace from manual segment space management to ASSM via the wizard in my dbconsole.

The wizard starts to create the script and then I get the followingin the impact report:

Tablespace <tablespace> contains object table <user.table>. Reorganization of object tables is not supported. Reorganization of this tablespace is not supported. It seems there is a line in the impact report for every table in the schema. The table space contains no LOBs and it appears that I can reorganize individual tables at will. Anyone have any suggestions? Thanks in advance.

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

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center