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...@amdocs.com>: > 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
