Browse by Tags

• EAE
• Java
• Linc
• OWNER
• SQL

• Easy way to see the Explain Plan in Oracle

  Linc\EAE used profiles for their queries. Well the profile information is used by our migration tool to generate indexes. In Java is easy to intercept all SQL statements used by the translated application and analyze them. To analyse how a query... Posted Feb 03 2010, 06:07 PM by Mrojas with | with no comments Filed under: Java, ORACLE, migration, Linc, EAE

• Get Table Owner in Oracle

  When we migrate from LINC/EAE to Oracle, the migration tool generates an schema an tables form the original ISPECS. I came across with the problem that I had been playing around with a test database and I didn’t know who was the owner of the table. Well... Posted Feb 03 2010, 05:40 PM by Mrojas with | with no comments Filed under: ORACLE, migration, SQL, OWNER, Linc, EAE