Browse by Tags

• DMSII
• Java
• Linc
• migration
• ORACLE
• OWNER
• SQL

• Escape characters for SQLLoader

  The LINC/EAE migration tool can automatically generate reports that can be used to extract your data from DMSII to your target database, for example Oracle. In this scenarios the Oracle SQL Loader tool is used. However you might problems loading... Posted Feb 09 2010, 11:49 PM by Mrojas with | with no comments Filed under: Java, migration, Linc, EAE, DMSII

• 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