Scripts

Toad for Oracle
1

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

2

SELECT
NAME,
REPLACE (REPLACE (text, CHR (10), ‘’), CHR (09), ’ ') function_code
FROM SYS.dba_source
WHERE owner = ‘’

3

Or Database > Export > Generate Schema Script

4

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!

5

“Generate Schema Script” in Toad requires the DBA Module.

If you don’t have that, you can multiselect tables in the schema browser,
rt-click and choose “Create Script”. Then repeat for other object
types.

-John

6

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

7

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

8

great! thanks for your help.

It works :slight_smile:

Thanks again!