We help IT Professionals succeed at work.

Toad option to generate schema DDL script

gudii9 asked
Medium Priority
Last Modified: 2013-12-18
I am using toad to connect to oracle 10g. I want to generate DDL script of entire schema/user say XYZ. I used to see the option earlier ie yesterday as in screenshot named 'ToadOption1' under
Database--->Export--->Generate Schema Script.

Now today I cannot see that option any more as in screenshot named 'ToadOption2'. How can i see the above option to 'generate schema script'. Can you please tell me step by step navigation for that to come. I am logging as same schema/user all same not sure why i am not able to see now. I am not sure what i did different today compared to yesterday.Please advise. Any resources, links, ideas, navigation steps highly appreciated. Thanks in advance.

Watch Question

David VanZandtSr Software Engineer
That's wicked!  I am out of the office until Tuesday, but allow me to make a stab at it.  Start with a full power off and restart on the PC.  Do the usual, bring up TOAD, and capture the version level you're on (current is around 9.7).  Ensure that you select an user account that has export_full_database granted, such as SYS (shouldn't make any difference to the software at this point, but....).
Is there any possibility that you have multiple copies of TOAD available?  Obviously, did anything on the PC change?
The right windows in the background are different, again, should be immaterial.
Let's go from there.

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts


Exactly. I do not have multiple copies of Toad. I did not do any chages to PC. Toad version on current machine is
I am granting all privileges to user/schema using command
grant all privilege to schema/user with ADMIN OPTION.
Please advise.
David VanZandtSr Software Engineer
I wish I could.... When you restart TOAD and open an instance, does the toolbar stay consistent -- what occurs over, say, three trials?  
A reminder if your organization has a non-trial version, you probably have a support contract with Quest.  Alternatively, try the knowledge base on www.toadworld.com.
I'll check back on Monday....

I have gone through the  www.toadworld.com. link but could not get the information needed. Please advise.
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.


Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.