Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Backup and Recovery
Message
From
23/10/2000 03:57:52
 
General information
Forum:
Oracle
Category:
Other
Miscellaneous
Thread ID:
00432367
Message ID:
00432740
Views:
19
Depending on your Backup Method...

1)These files are backed up when you backup the tablespace that contains them.

2)If you do an export (exp command) you can backup your stored procedures.

3)MY method like Marks is to save a text file that I used to create the stored procedures.

You can get all you stored procedures out of the Database by...
select 'CREATE OR REPLACE '||name||' AS '||text from user_objects
where type='PROCEDURE';

You could spool this to a file and you would have the text for the stored procedures...(remeber to save the name....)

HTH
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform