segunda-feira, 17 de agosto de 2015

OBIEE Administration Tool show no tables

Its complicated when you have to import some tables using oracle Admin Tools and there show no tables! You run to the database and they are there.

Ok, to fix it, you have to download Oracle Database Client, and install OCI (Oracle Call Interface)
Oracle Call Interface (OCI) is the comprehensive, high performance, native C language interface to Oracle Database.  It exposes the full power of Oracle Database to custom or packaged C applications.  Oracle In-Memory Database Cache also supports access from OCI programs. http://www.oracle.com/technetwork/database/features/oci/index-090945.html
To download Client for Oracle Database 11g Release 2:
http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-win64soft-094461.html


After download, when installing, select Oracle Call Interface (OCI) and finish.

Now you can import yout tables and schemas on import metadata wizard with no problem!!

This happend because the library 'oracore11.dll' isn’t provided by InstantClient, so you must install the full Oracle Client.

Nenhum comentário:

Postar um comentário