HFM version: 22.214.171.124 on windows
database 11gr2 on oul5x64
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
ON COMMIT PRESERVE ROWS
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.