Spatial (MOSC)

MOSC Banner

Spatial Index Rebuild and segments associated with spatial indexes

edited Apr 4, 2013 4:32AM in Spatial (MOSC) 5 commentsAnswered
I've got a script that builds a partitioned spatial index in several different tablespaces.  However it appears that all of the partitions are being built in the same tablespace (F_DEFAULT_SPATIAL) and that tablespace is running out of space LONG before all of the partitions are rebuilt (about 60 of 2000 complete).  A small part of the script is below.  Can you suggest the correction necessary to build the segments in the correct partitions? 

I'm coping the table from a different database.  The F_DEFAULT_SPATIAL tablespace is 87G on the source and 132G on the destination so that shouldn't be a problem.

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