Activity overview
Latest activity by upliha
Hi Eddie,
I found the "solution". The verbose log showed that the user needs the privilege to read system table SYS.OBJ$.
So when adding the SELECT_ANY_DICTIONARY priv everything works just fine.
You can close the ticket you opened. I wasn't able to login anyway since my email address didn't match with the password I use for this forum (in conjunction with my username).
Anyway, your advise with the verbose log helped a lot. Schema Compare works like a charm now.
Kind regards
Uwe / comments
Hi Eddie,
I found the "solution". The verbose log showed that the user needs the privilege to read system table SYS.OBJ$.
So when adding the SELECT_ANY_DICTIONARY priv everything works just fine.
Y...
It looks like Schema Compare has problems with tables using a IDENTITY columns.
I built up a schema with a simple table and it worked. Adding a table with GENERATED ALWAYS AS IDENTITY made Schema Compare come up with an error.
I'm using an Instand Client 12.1.0.2.0 on a Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production.
So what now?
Regards
Uwe / comments
It looks like Schema Compare has problems with tables using a IDENTITY columns.
I built up a schema with a simple table and it worked. Adding a table with GENERATED ALWAYS AS IDENTITY made Schema C...
ORA-00942 when registering database
Hello,
when comparing a DB schema to a scripts folder it always aborts on step "Populating" when registering database one with "ORA-00942 table or view does not exist".
What am I missing? I'm conn...