1 Reply Latest reply on Mar 3, 2020 11:23 AM by user5183465

    create table XMLTYPE COLUMN "XMLCONTENT" STORE AS BASICFILE CLOB -> ORA-01031

    user5183465

      Der Scirpt wird unter ADMIN in der Oracle Cloud Autonomous Database ausgeführt. Welche Rechte werden hier benötigt und wer kann diese Rechte erteilen?

      The scirpt is carried out under ADMIN in the Oracle Cloud Autonomous Database. Which rights are required here and who can grant these rights?

       

      Script:

        CREATE TABLE "IB_FLEX_TEST"

        ( "IBFLEX_SEQ" NUMBER(10,0) NOT NULL ENABLE,

        "AKTIV_JN" NUMBER(1,0) DEFAULT 1 NOT NULL ENABLE,

        "LOG_CR_TIME" DATE DEFAULT SYSDATE NOT NULL ENABLE,

        "LOG_UP_TIME" DATE,

        "XMLCONTENT" "SYS"."XMLTYPE" ,

        CONSTRAINT "IB_FLEX_PK" PRIMARY KEY ("IBFLEX_SEQ")

        );

        drop table ib_flex_test;

        CREATE TABLE "IB_FLEX_TEST"

        ( "IBFLEX_SEQ" NUMBER(10,0) NOT NULL ENABLE,

        "AKTIV_JN" NUMBER(1,0) DEFAULT 1 NOT NULL ENABLE,

        "LOG_CR_TIME" DATE DEFAULT SYSDATE NOT NULL ENABLE,

        "LOG_UP_TIME" DATE,

        "XMLCONTENT" "SYS"."XMLTYPE" ,

        CONSTRAINT "IB_FLEX_PK" PRIMARY KEY ("IBFLEX_SEQ")

        )

        XMLTYPE COLUMN "XMLCONTENT" STORE AS BASICFILE CLOB ;

       

      Output:

       

      Table "IB_FLEX_TEST" erstellt.

       

       

      Table IB_FLEX_TEST gelöscht.

       

       

      Fehler beim Start in Zeile: 58 in Befehl -

        CREATE TABLE "IB_FLEX_TEST"

        ( "IBFLEX_SEQ" NUMBER(10,0) NOT NULL ENABLE,

        "AKTIV_JN" NUMBER(1,0) DEFAULT 1 NOT NULL ENABLE,

        "LOG_CR_TIME" DATE DEFAULT SYSDATE NOT NULL ENABLE,

        "LOG_UP_TIME" DATE,

        "XMLCONTENT" "SYS"."XMLTYPE" ,

        CONSTRAINT "IB_FLEX_PK" PRIMARY KEY ("IBFLEX_SEQ")

        )

        XMLTYPE COLUMN "XMLCONTENT" STORE AS BASICFILE CLOB

      Fehlerbericht -

      ORA-01031: Nicht ausreichende Berechtigungen

      01031. 00000 - "insufficient privileges"

      *Cause: An attempt was made to perform a database operation without

        the necessary privileges.

      *Action: Ask your database administrator or designated security

        administrator to grant you the necessary privileges