Log-In to post
Answers to your most common questions about Toad World
NOTE: This forum is for questions and discussions concerning the Toad World website and not for products/platform. Please post product/platform questions in their respective forums. Thanks!
I want to import data from Excel to a toad , my data as much as 517 982 thousand . and failure as shown below.kode eror ( all rows errored. No rows were imported)
I am trying to create user creation script which would contain all roles and grants using the following script which is missing/ not formatting as AQ privileges:
SELECT DBMS_METADATA.GET_DDL('USER', USERNAME) || '/' DDL
SELECT DBMS_METADATA.GET_GRANTED_DDL('ROLE_GRANT',USERNAME) || '/' DDL
SELECT DBMS_METADATA.GET_GRANTED_DDL('SYSTEM_GRANT', USERNAME) || '/' DDL
SELECT DBMS_METADATA.GET_GRANTED_DDL('OBJECT_GRANT', USERNAME) || '/' DDL
Perhaps, when i same create user script using TOAD it comes with all create user script with required roles and grants script on top of it following format.
SYS.DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE( PRIVILEGE => SYS.DBMS_RULE_ADM.EXECUTE_ANY_EVALUATION_CONTEXT, GRANTEE => USERNAME, GRANT_OPTION => FALSE);
Anyone has idea about how to generate similar script using DBMS_METADATA or how TOAD does this smart way?
Thanks in advance,
What is a 'community' ? I tried to click on a 'community' but don't really know what that means
in this context. Does it mean a Platform, or a Product ?
I clicked on a community, then clicked on Forum and no button saying Post New Thread came up.
on the page "http://www.toadworld.com/products/toad-extension-for-eclipse" there is a link named "Install the Community Edition".
this link leads to a error page:
Page Not FoundUnfortunately, the page you've requested no longer exists. Please use the search form below to locate the information you're interested in.