[Last Call] Learn how to a build a cloud-first strategyRegister Now


Toad option to generate schema DDL script

Posted on 2009-02-13
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.

Question by:gudii9
  • 2
  • 2
LVL 23

Assisted Solution

David earned 2000 total points
ID: 23640504
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.

Author Comment

ID: 23641531
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.
LVL 23

Assisted Solution

David earned 2000 total points
ID: 23641979
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....

Accepted Solution

gudii9 earned 0 total points
ID: 23684572

I have gone through the  www.toadworld.com. link but could not get the information needed. Please advise.

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
Via a live example, show how to take different types of Oracle backups using RMAN.
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
Suggested Courses
Course of the Month18 days, 2 hours left to enroll

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question