Re: ora2pg - Java Message Service (JMS) Type

[Poul Kristensen <bcc5226@xxxxxxxxx>]

The R statistic software is using PostgreSQL. Oracle has a module to transform PostgreSQL tables very easy both ways. Just install R and the module. I can't remember the name of the module but try googling. 

Hope it helps.

/Poul

 

2016-12-09 18:22 GMT+01:00 Joanna Xu <Joanna.Xu@xxxxxxxxxx>:

Hi All,

 

We plan to use ora2pg tool to migrate Oracle to PostgreSQL.  During the testing, while importing content of the output.sql into PostgrSQL database, it terminated with the following error “ERROR:  type "aq$_jms_text_message" does not exist” for “user_data” column with “AQ$_JMS_TEXT_MESSAGE” as type.  In this case, if Java Message Service (JMS) types are not supported by Postgres, ora2pg would not be the right tool to use for the migration but I am not certain if it is true.  Can someone please advise?

 

psql -d wsp -U staging -W < /database/postgres/outputSTAGING.sql

Password for user staging:

SET

CREATE TABLE

:

CREATE TABLE

ALTER TABLE

CREATE INDEX

ERROR:  type "aq$_jms_text_message" does not exist

LINE 29:  user_data AQ$_JMS_TEXT_MESSAGE,

 

Thanks,

Joanna

This message and the information contained herein is proprietary and confidential and subject to the Amdocs policy statement, you may review at http://www.amdocs.com/email_disclaimer.asp

--

Med venlig hilsen / Best regards
Poul Kristensen
Linux-OS/Virtualizationexpert and Oracle DBA