On Mon, Dec 12, 2016 at 04:15:59PM +0000, Joanna Xu wrote:
> On Fri, Dec 11, 2016 12:43 PM, Julien Rouhaud wrote:
> >>I forwarded your mail to the author, since he's not on this mailing-list. This issue should be fixed with commit
>>https://github.com/darold/ora2pg/commit/2c22d377e9f90fa6fa83cfe1fbead9eb3396a0f3.
>
> >>If this bugfix is not enough or if you find other issues, could you report them directly on github
(https://github.com/darold/ora2pg/issues)?
> Hi Julien,
> Thanks for looking into the issue.
>
> I tried and updated "Ora2Pg.pm" with the change suggested in
https://github.com/darold/ora2pg/commit/2c22d377e9f90fa6fa83cfe1fbead9eb3396a0f3(add "|TYPE" in the following line) but
encounteredthe same issue "ERROR: type "aq$_jms_text_message" while import the content of the output.sql into
PostgreSQLdatabase.
>
> [kll0199:/u01/app/oracle/ora2pg-17.6/lib] egrep "has_limitation" Ora2Pg.pm | egrep -v "has_limitation ="
>
> if (!$self->{is_mysql} && !$has_limitation && ($arr_type[$i] =~ /TABLE|SEQUENCE|VIEW|TRIGGER|TYPE/))
{
>
> At this point, I guess the issue occurred for that particular type "aq$_jms_text_message". So the key question would
be: does Postgres database support "aq$_jms_text_message" type? If postgres does not support this type, it will error
out. I would need confirmation on this please.
>
Unfortunately I have no idea what's "aq$_jms_text_message" type, but I don't
see any reason why it couldn't be migrated to PostgreSQL. It really seems that
ora2pg miss to migrate this type for some reason, so you should open an issue
on https://github.com/darold/ora2pg/issues. The author will have a better
answer than me on your problem.
--
Julien Rouhaud
http://dalibo.com - http://dalibo.org