Toad option to generate schema DDL script

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

    Assisted Solution

    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.
    LVL 7

    Author Comment

    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

    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
    I'll check back on Monday....
    LVL 7

    Accepted Solution


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

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Article by: Swadhin
    From the Oracle SQL Reference ( we are told that a join is a query that combines rows from two or more tables, views, or materialized views. This article provides a glimps…
    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…
    This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
    This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

    760 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

    Need Help in Real-Time?

    Connect with top rated Experts

    7 Experts available now in Live!

    Get 1:1 Help Now