Hello everyone,
I'm having some issues for quite some time now regarding exporting data from a Revit project to my database. The following is my environment:
Windows 7 - 64-bit
Oracle Database 11.2.0.1
Revit 2015
The first couple of times, i was able to export data from the project to a newly created schema "REVIT" (given the appropriate grants).
The first time the project was exported without any problems. The next time, i tried exporting the same project to another schema "REVIT2", i got this error from the ODBC:
[42S02] [Oracle][ODBC][Ora]ORA-00942: table or view does not exist (942)
Ever since, i've not been able to export any project to any schema!!
I tried searching for this error but i couldn't find anything on the Autodesk forums. I was going to ask this question there when i read the ODBC documentation (C:\Oracle\product\11.2.0\dbhome_1\odbc\html\ODBCRelnotesUS.htm).
Under Software Required it said:
Microsoft Windows XP and for Unix platforms refer to release notes on Oracle ODBC Driver release for Unix platforms.
Oracle Net Client 11.2.0.1.0
Oracle Universal Installer shipping with Oracle 11.2.0.1.0
I thought, maybe the first time worked but things got messed up afterwards (since i'm using Windows 7). So i read a post for a similar case that proposed downloading a different ODBC driver as one solution. So i downloaded the instantclient-basic-windows.x64-11.2.0.4.0.zip and instantclient-odbc-windows.x64-11.2.0.4.0.zip. I deployed the Instant Client Basic and installed the ODBC successfully.
I was able to create and test the connection successfully from the ODBC Administrator Console. However, i'm still getting the same error!
Any ideas?
Thanks in advance
.
M. Fadel