Toad World® Forums

Reverse Engineering - Oracle cross schema


#1

I am trying to Reverse Engineer (RE) database objects from a specific schema and have Foreign key links to cross schema. The RE utiility shows me only my current schema objects. How do I see other schemas using my own user id’s. I have access to the other schemas within the same database.

Appreciate your reply.

Thanks
Mohan


#2

Hello Mohan,

Please try to do the following: In the Options step in the RE Wizard, select also the "Load All Accessible Objects “All_” check-box.

It should help.

Regards,

Vladka & TDM Team


#3

Hi,
Thanks for the update. It did show me all the schema objects, but while RE it gave me the below error.
Source:CS3 - Internal Error
Script: RE Oracle 9i
Description: [Oracle][ODBC]Invalid descritor index <4>.
Row:304
Column: 5

Callstack:

It does connect to the database and shows me all objects but when I select an object and RE it gives the above error.
Sugession: An Help button besides the error would be helpful to give a hint to trace out what the error is.
Please let me know how to resove this.

Thanks
Mohan


#4

Hi,

Yes, the problem has already been reported (CR # 29 428) at:
http://modeling.inside.quest.com/thread.jspa?threadID=2688&tstart=0

Current solution: Please use ADO connection, the " Microsoft OLE DB Provider for Oracle" provider.
Thanks in advance!

Regards,

Vladka