Posted on 2011-03-11
Last Modified: 2012-05-11
I have a CDR schema and I want to get the scripts of all the objects which
includes tables, views, jobs, sequences packages, procedures , functions, mview
etc., anythng that are on that schema

Is there any way I can get this done thru TOAD?

Please respond asap

Question by:d27m11y
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 2
  • 2
LVL 77

Accepted Solution

slightwv (䄆 Netminder) earned 125 total points
ID: 35112706
Check out:

if you're using version 9.6 then follow these steps...

1. Select Database Menu Option
2. Database Menu -> Export -> generate schema scripts

3. in rhs window choose select the schema and then press the green play button


Author Comment

ID: 35112726

Am using 9.6.1.. Let me try the option what you have said

Author Comment

ID: 35112791

Is there any option that I can get all the scripts of the Tables separately , views separately, packages separately instead of everythng combined
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!


Author Comment

ID: 35112876

Also, for some schemas I am not able to generate script. Is this a privilege issue. If so, can anyone suggest what kind of privilege do I need?

Quick reply is appreciated!

Assisted Solution

swadhinray earned 125 total points
ID: 35125176
check this link hope this will give you an idea on your queries :

you can choose individually for each option by selecting them while generating the DDLs.

Expert Comment

ID: 35125181
Sorry not on export  DDL  but on Generate schema script.

Author Comment

ID: 35129107

I am able to generate schema script from TOAD and it is quite helpful. Is there anyway that I can get each of the procedures/functions/views scripts separately generated thru TOAD?

Quick reply is appreciated
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 35129346
Sorry, I'm not a Toad user.  I suggest you refer to the help section of Toad for assistance.

You can also click the 'Request Attention' link above and as the Moderators to see if they can locate q Toad Expert to offer more help.

Assisted Solution

d27m11y earned 0 total points
ID: 35129391

I think I got it. I used

In ‘Generate Schema Script’, there is an option ‘Create Individual Object DDL Files’.   This will create separate files for each object.

This works thru TOAD !

Author Closing Comment

ID: 35170843
Resolved the issue!

Featured Post

Secure Your Active Directory - April 20, 2017

Active Directory plays a critical role in your company’s IT infrastructure and keeping it secure in today’s hacker-infested world is a must.
Microsoft published 300+ pages of guidance, but who has the time, money, and resources to implement? Register now to find an easier way.

Question has a verified solution.

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

Suggested Solutions

Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
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 with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
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.

735 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