ANAME B CREATE TABLE CREATE TABLE ( INDEX 1 1 TABLE 2 1 ) ORGANIZATION EXTERNAL ; ANAME B INSERT TABLE INSERT /*+ APPEND PARALLEL(" ", ) +*/ /*+NESTED_TABLE_SET_SETID+*/ INTO RELATIONAL( NOT XMLTYPE ) ( INDEX 2 0 ) 2 SAMPLE ( ) KU$ ; ANAME B SELECT TABLE 3 SAMPLE ( ) KU$ ; ALONG_POSITION B ANAME B INSERT TABLE INSERT /*+ APPEND PARALLEL(" ", ) +*/ /*+NESTED_TABLE_SET_SETID+*/ INTO RELATIONAL( NOT XMLTYPE ) ( INDEX 4 0 0 0 ) VALUES ( INDEX 5 1 0 ) ; AS 1 RELATIONAL( @ NOT XMLTYPE ) SAMPLE ( ) AS OF SCN KU$ ***ERROR: UNEXPECTED OPERATION_TYPE: ; " ANAME B DROP TABLE DECLARE stmt VARCHAR2(2000); TABLE_NOT_EXIST exception; pragma EXCEPTION_INIT(TABLE_NOT_EXIST, -942); BEGIN stmt := 'DROP TABLE PURGE'; EXECUTE IMMEDIATE stmt; EXCEPTION WHEN TABLE_NOT_EXIST THEN NULL; END; / " ". " " ET$ 1 SELECT /*+ PARALLEL(KU$, ) */ INDEX 1 0 1 FROM PARTITION ( " " ) SUBPARTITION ( " " ) INSERT TABLE DECLARE CURSOR C1 IS SELECT INDEX 0 1 1 FROM @ AS OF SCN ; BEGIN FOR C1_REC IN C1 LOOP INSERT INTO VALUES ( INDEX 0 0 C1_REC. ); END LOOP; END; INSERT /*+ NESTED_TABLE_SET_REFS */ INTO ( ) SELECT /*+ NESTED_TABLE_GET_REFS */ 1 FROM @ AS OF SCN KU$ ; 0 NESTED_TABLE_ID, SYS_NC_ROWINFO$ SYS_NC_ROWINFO$ SYS_NC_OID$, SYS_NC_ROWINFO$ NESTED_TABLE_ID, COLUMN_VALUE INDEX 0 1