Savin a script in Oracle

[Anea]

I know I can save all my stored procedures and views in one script in MS SQL, but how to do the same thing in Oracle?

[sreddy]

You have all yours source in dba_source, text column. You can spool tht text column to a script.

[Anea]

where can I find that dba_source?

[Oracledba8]

DBA_SOURCE is a View in Data Dictionary...
If you don't have DBA Priviliges, just select like this

Select Text From User_Source
Where name = Upper('&ObjectName')
and Type = Upper('&ObjectType')
Order by Line;

It will ask you Object Name, and Type, Give your Procedure name, Function name or Package name... and The Type either it is Procedure , Package etc . You will get the Results.

Thanks

[Anea]

I tried that and I'm getting all kind of information that I really don't want. I need only procedures and view. Is there any way to do it using GUI?

[mber]

Probable you can do one thing:

Download the toad tool from the web, that can export you procedures to either one file or separate files as you want.

Take care

[Anea]

I can't find that TOAD thing and I decided to try it from SQL Spreadsheet but now it's not working. What should I do now?

[6502]

[QUOTE][i]Originally posted by Anea [/i]
[B]I can't find that TOAD thing and I decided to try it from SQL Spreadsheet but now it's not working. What should I do now? [/B][/QUOTE]

Hi,

I use the SQL-Navigator from Quest-Software (this company took over the TOAD, too). This tool may be expensive, but it's worth it. ( [url]http://www.quests.com/[/url] )
A script that generates a procedure is generated and saved with 5 mouseclicks.

Commit;
6502

[Anea]

Can I do it without any tool?
It's not working with dba_source.

[Oracledba8]

What do you mean it's not working from dba_source...?

I already gave you the statement, instead of using dba_source, just use user_source.

Tha should be fine..