ORA-00942 when registering database

uplihaupliha Posts: 4
edited December 2, 2016 8:24AM in Schema Compare for Oracle
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 connecting with the same user of the schema I'm comparing. The very user should have all privileges on its own objects.
So what table is missing? Does the connected user need special privileges or even DBA-privs?

Any advise is appreciated as I am evaluating this product and I'm confused that this first simple step doesn't work.

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 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
  • Hi Uwe,

    Thank you for your forum post and sorry to read that you have encountered a problem.

    A support ticket has been created for you. The ticket created can you reviewed or updated via the support portal using this LINK.

    Would you please enable the verbose logging as per this help document.

    Repeat the comparison attempt, when the error occurs, please screen shot the error and locate the log file generated and either the support ticket via the support portal or attach the files to an email and send to support@red-gate.com quoting call reference #78294.

    The user account specified for the Oracle connection, needs security permissions to several data dictionaries and I suspect the user account does not have these permissions. I will be able to confirm this once we have received the log file and screen shot requested.

    Many Thanks
    Eddie
    Eddie Davis
    Technical Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
  • 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
  • jgarecjgarec Posts: 1 New member
    Hi Eddie,

    Could you update this part of the documentation : https://documentation.red-gate.com/sco4/troubleshooting/privileges-required-to-compare-and-deploy-using-schema-compare-for-oracle ?

    Maybe you could describe the creation of a dedicated user with minimalist grants to allow SCO to work with identity columns. Is SELECT_ANY_DICTIONARY really necessary (which is ok as a workaround for us) ?

    Best Regards,
    Jérôme
Sign In or Register to comment.