Issues with SHOW_TABLE not showing all tables in oracle about ora2pg HOT 12 CLOSED

Hi,

Does this table is listed in ALL_OBJECTS and what is its type in this catalog table?

SELECT A.OWNER, A.OBJECT_NAME, A.OBJECT_TYPE FROM ALL_OBJECTS A WHERE A.OBJECT_NAME = 'V_STOFF_ZEUS_NEU';

It might not be a real table but related to materialized view, in this case the OBJECT_TYPE will not be TABLE.

from ora2pg.

from ora2pg.

There is materialized view with the same name. Maybe that is the reason?

from ora2pg.

yes this is the reason

from ora2pg.

but the table should be exported despite the existence of a materialized view right?

from ora2pg.

right, give me few minutes.

from ora2pg.

@mirec84 please give a try to latest development code, commit fc5c67c should fix this issue.

from ora2pg.

Well I introduced a regression in the previous commit that is fixed with commit 6f3ffc1, please give it a try.

from ora2pg.

I still do not see the V_STOFF_ZEUS_NEU table :( Nothing seem to be changed in the output

from ora2pg.

Ok, I have reverted the lasts commits. What you are seeing is an Oracle internal table related to the materialized view, not a real table.

You can try to create a materialized view and execute query SELECT A.OWNER, A.OBJECT_NAME, A.OBJECT_TYPE FROM ALL_OBJECTS A WHERE A.OBJECT_NAME = '<MVIEW_NAME>'; you will see the two entries. Previous behavior of Ora2Pg was the right one. I should have recall that you can not create a table and a mview with the same name in Oracle.

from ora2pg.

You are correct

from ora2pg.

this is not an issue

from ora2pg.