Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 326
  • Last Modified:

Scripts

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

Thanks
0
d27m11y
Asked:
d27m11y
  • 6
  • 2
  • 2
3 Solutions
 
slightwv (䄆 Netminder) Commented:
Check out:

http://www.experts-exchange.com/Database/Oracle/Q_24037756.html

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

0
 
d27m11yAuthor Commented:

Am using 9.6.1.. Let me try the option what you have said
0
 
d27m11yAuthor Commented:


Is there any option that I can get all the scripts of the Tables separately , views separately, packages separately instead of everythng combined
0
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
d27m11yAuthor Commented:


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!
0
 
swadhinrayCommented:
check this link hope this will give you an idea on your queries :

http://www.experts-exchange.com/Database/Oracle/10.x/Q_24142724.html

you can choose individually for each option by selecting them while generating the DDLs.
0
 
swadhinrayCommented:
Sorry not on export  DDL  but on Generate schema script.
0
 
d27m11yAuthor Commented:

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
0
 
slightwv (䄆 Netminder) Commented:
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.
0
 
d27m11yAuthor Commented:

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 !
0
 
d27m11yAuthor Commented:
Resolved the issue!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 6
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now