Creation of Mview with connect_by_root fails with ora-30361 (Doc ID 331669.1)

Last updated on JULY 07, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 10.1.0.2 and later
Information in this document applies to any platform.

Symptoms

Small test case describes and reproduces the problem.

 

DROP TABLE tt1;
CREATE TABLE tt1 (
  cid number,  -- current ID
  pid number,  -- parent ID
  val number);
INSERT INTO tt1 VALUES (1, 0, .1); 
INSERT INTO tt1 VALUES (2, 1, .2); 
INSERT INTO tt1 VALUES (3, 1, .3); 
INSERT INTO tt1 VALUES (4, 1, .4); 
INSERT INTO tt1 VALUES (5, 2, .5); 
INSERT INTO tt1 VALUES (6, 2, .6); 
INSERT INTO tt1 VALUES (7, 4, .7); 
COMMIT;

 

 

create materialized view RR as
select connect_by_root cid cidt, val
   from tt1 connect by cid=prior pid

ORA-30361: unrecognized string type

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms