High Availability Data Guard, Sharding and Global Data Services (MOSC)

MOSC Banner

18c sharded table split issue

Hi All.

Still looking issues solution that i am facing in my user defined sharding 18c.

As per your advised i used following query to split my partition with same shard and with same shard's tablespace. but still giving me error . pls check

ALTER TABLE location SPLIT PARTITION location_NODE4_P24  AT (TIMESTAMP' 2018-05-01 00:00:00') INTO (PARTITION location_NODE4_P24 tablespace Node4_TS_8 , PARTITION location_NODE2_P25  TABLESPACE Node4_TS_9 ) update indexes

                 *

ERROR at line 1:

ORA-00604: error occurred at recursive SQL level 1

ORA-02680: unsupported construct referred in the query

So please guide me what i do , what process i have to follow.

Tagged:

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