When trying to setup Private script repository in a database (View | Toad options | Online | Script Repository | Private) a ORA-00942 error is given after providung SMTP info.
Toad runs the following and b/c ACL is not set up on the database, this error is encountered.
select acl
from dba_network_acls
where acl = '/sys/acls/mail_access.xml'
Error occurred: [942] (ORA-00942: table or view does not exist)
The database is not set up with ACL and XML DB. Can a Toad private script repository be installed without installing ACLS /XMLDB? Is it possible to skip that mail server checking?
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center