Toad World® Forums

EXPORT ERROR


#1

I use toad 4.6 and right click on table name and use the utility to export table data and change the query statement then execute,but encounter problem ,and it’s OK when use toad 4.5, please help find out how to solve it,thanks a lot.

p.s.the message is as below

SQL3104N The Export utility is beginning to export data to file
“D:\ToadRoot\DBDF.DTDFC006.ixf”.

SQL0551N “” does not have the required authorization or privilege to perform
operation “” on object “”.

SQL3015N An SQL error “-551” occurred during processing.

SQL0551N “DBDF” does not have the required authorization or privilege to
perform operation “EXECUTE” on object “NULLID.SQLUBH05”. SQLSTATE=42501

SQL3105N The Export utility has finished exporting “0” rows.

Message was edited by: Pyro

EXPORT ERROR.jpeg


#2

My partner has found the solution, it’s

GRANT EXECUTE ON PACKAGE NULLID.SQLUBH05 TO PUBLIC

so please don’t reply the message,thanks.