ORACLETag Archive

Following type of SQL’s can cause “subquery in FROM must have an alias” issue. They are like below, It needs to be fixed to meet the SQL standards. There is no question asked about why PostgreSQL did not support 🙂 why should I create alias in all the cases 🙂… Continue Reading ORA2PG MIGRATION – Subquery must have an alias

The code like this in your program can throw “Data Type Mismatch Error” at run time. Following is the actual runtime error will come in the application, Caused by: org.postgresql.util.PSQLException: ERROR: operator does not exist: smallint <> character varying  Hint: No operator matches the given name and argument types. You… Continue Reading Ora2Pg Migration – Data Type Mismatch Error

If you face Insufficient privileges issue while connecting to oracle database from Amazon AWS Schema Conversion Tool (SCT) like below, ORACLE Server : [SELECT ANY DICTIONARY] Run following command as system user in oracle server, grant select any dictionary to abc_owner;