I'm trying to get a DTS package to import data from Oracle into an existing SQL Server table. I can construct my query with no
problem in the Query Builder but it fails at runtime with "ORA00942
table or view doesn't exist".
I've been using Oracle's 9.02.00.05 driver. I also tried MS ODBC
Oracle driver 2.575.1117. And I saw a post suggesting the OLE DB
driver which I tried also. The connections always test fine but I
still get the error when I run the package.
Oracle parameter problem with OraOLEDB driver ... both Oracle and SQL Server. ... I am using this driver rather than the ... I have a query which contains parameters, one of which is an integer. ... query has its datasource value set to a datasource as it is the detail part ... (borland.public.delphi.database.ado)
Replace and Update ... MSAccess linking to Oracle 8 tables with Microsoft ODBC for Oracle ... This query returns the correct information. ... (comp.databases.ms-access)
Re: Views - performance ... when u use stored object views oracle has to read the data dictionary ... this includes lots of steps for execution... semantics of the query and fires it ... you'll possibly have any idea is to use explain plan to provide a base ... (comp.databases.oracle.server)
Re: Equilevant of Oracle for optional records ... and a normalized t2 could be more useful, to build the query, and once this ... the Iqaluit Trauma:...Oracle handles this data structure perfectly but I suspect it might be ... (microsoft.public.access.queries)
