Right now I am using External Tables Oracle I am not certain if it can load for example 20,000 records or more.

Is there any means of reading answer information (WSID) in backend? I have The Oracle Reading used UTL FILE but it is limited to 32,767 characters. You're in good company this Editor Oracle slightwv Featured Expert actonwang Ask An Expert Now! I can cover the metadata from Navision so I see the tables and its columns. I make suitable would between Oracle and SQL Server. External Tables can Reading handle any number of records.

Take real peek into other realms and dimensions. Though hidden, these realms tell very real.

• I tried with different options Navision DSN of Reading Oracle The ODBC Driver which I thought was the correct one, name of the database file weird!
• Ask The The - FREE Interactive Oracle Turn Your Life into Gold!
• Navision an ERP with a own database not a database like Oracle.
• I to load thousands of records from a file using PLSQL.
• UTL FILE gives you more control, but more work.

We test the connections in OWB, with an Oracle and it works. Or if External Tables are recommended for scenario. So the question is: does know what name do I have to name the LOCATION so the deployment goes fine?

The system was quite difficult to set up because the database is in a Linux machine and Navision 2. Oracle technology is constantly changing and we strive continually update our database information. Comment from Date: 09 01 2004 03:32AM PDT Comment UTL FILE although will provide flexibility, SQL Loader will give you performance.