Toad World® Forums

TDA 2.6 - Viewer - Script Tab Fails for Oracle DBs'


#1

Hello

The following message is returned when “Script” is selected in the Viewer Window

The requested database object information has not been retrieved.
Object information is retrieved by SYS.DBMS_METADATA.
Check to see that you have privileges for this package.

But in previous versions of TOAD (e.g. Toad For Oracle) this same function works fine (using same databases / and authentication)

We have multiple databases - on is on 10g
another on

Any thoughts?

As mentioned - I am surprised by thuis because in Toad for Oracle this function works with absolutely no problems - but in TDA 2.6.2.580 this seems to berak


#2

Toad for Oracle and TDA are different code bases. Toad for Oracle generates the DDL manually. TDA is using the DBMS_METADATA package from Oracle. To use this you need to have the proper privileges.

Try doing a right click from the object explorer and choosing generate SQL | to Editor | Generate DDL. This may not be using this package.