This discussion is archived
1 Reply Latest reply: Dec 13, 2012 3:39 PM by papaez RSS

ORA-00902: invalid datatype

user3715462 Newbie
Currently Being Moderated
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,

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points