Jump to content


  • Content count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About mrehman_kahloon

  • Rank
  1. mrehman_kahloon

    18c user defined sharding

    Hi Sir, thanks for your response, 1-- split partition command that i am using , target tablespace is on same shard, ALTER TABLE location SPLIT PARTITION location_NODE4_P24 INTO (PARTITION location_NODE4_P24 VALUES LESS THAN (TIMESTAMP' 2018-05-01 00:00:00') 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 2-- sqlloder giving me following ora error ORA-02681: array DML not supported on a sharded table 3-- offloading mean simply alter table exchange partition. Regards, Kahloon
  2. mrehman_kahloon

    18c user defined sharding

    hi, 18c user manged sharding with range partition, need help in following issues 1 catalog db,3shards , each shard has 5 tablespace and different date data. 1-- how can i split my maxvalue partition into new partition, when i try recursive sql errors show 2-- can't load bulk load, as we are used to in simple tables , array dml not suported on sharded table 3-- how can i offload data from sharded table , alter table exchange partition please guide me what i do now, thanks