1 Reply Latest reply: Dec 13, 2012 5:39 PM by papaez RSS

    ORA-00902: invalid datatype

    user3715462
      Hi All,

      not sure i am in the right forum.

      HFM version: 11.1.2.1 on windows
      database 11gr2 on oul5x64
      schema: HFM
      question:i am cloning schema HFM to HMF2 on the same database using datapump .
      when import back into HFM2 schema there was an error "ORA-00902: invalid datatype "
      oracle does not have this data type.

      here is the script:
      CREATE GLOBAL TEMPORARY TABLE HFM2.TEMP_VARRAY_TABLE
      (
      DIMID NUMBER,
      DIMARRAY HFM2.TYPE_NUMVARRAY
      )
      ON COMMIT PRESERVE ROWS
      NOCACHE;

      Well...open and SR with database team and they suggested me to open it with application team " HFM is not a database schema, it is an application schema."

      ...so open an SR with application team

      "the table "TEMP_VARRAY_TABLE" is not created within HFM database by default, possibly it could be manually created."
      and again suggested me to open an SR with database team to confirm.

      Can someone please give me some thoughts on this error.

      Thanks in advance.
      Regards,