How do I take a backup of Stored Procedure in Oracle?

Question Posted / roopa

3 Answers
30382 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How do I take a backup of Stored Procedure in Oracle?..

Answer / roopa

SELECT
DBMS_METADATA.GET_DDL
('PROCEDURE','<PROCEDURE_NAME>','<SCHEMA_OWNER>')
FROM dual;

Is This Answer Correct ?

15 Yes

0 No

How do I take a backup of Stored Procedure in Oracle?..

Answer / awa

SELECT
DBMS_METADATA.GET_DDL('PROCEDURE',a.object_name,a.owner)
FROM = dba_objects a WHERE OWNER =3D'SCHEMA_OWNER' AND
object_TYPE =3D'PROCEDURE' ORDER BY owner

Is This Answer Correct ?

6 Yes

1 No

How do I take a backup of Stored Procedure in Oracle?..

Answer / syed

Go to oracle bin directory and run the export file
it will ask you in the question format

just say 'yes' or 'y' for data with procedure and funcion.

it will include all the procedure and function view and
table.

Is This Answer Correct ?

3 Yes

10 No

Post New Answer

More Database Management Interview Questions

How to recreate the index on a firebird table?

0 Answers

Explain the Normalized Relations?

0 Answers

What is the database approach?

0 Answers

for what purpose we use MDM(master data management)tell me plz.

0 Answers

What is the mechanism provided by ORACLE for table replication ?

1 Answers

What is difference between database and website?

0 Answers

What do you understand by query optimization?

0 Answers

What is normal form in dbms?

0 Answers

what is Data Definiton Language ?

0 Answers

How rdbms is different from dbms?

0 Answers

Explain vdl (view definition language)?

0 Answers

8. Sort, Lookup What kind of technique (partition) is used? 9. How can you handle exceptions in job sequencer? 10. How do you apply custom conditions an exceptions (How do you trigger exceptions in job sequence?) 11. I have a job with 3 possibilities? Finish with ok…..Abort…….Warning} How do you handle these in Job sequencer 12. How do you connect both OK and Warning can we? 13. How to find which process is running currently? 14. How do you find the disk usage in UNIX? 15. How do you combine 2 sequential files having same metadata of same file names? 16. How do you implement SCD in Ds? 17. Explain the situation where you have applied? 18. How do you apply new changes to? 19. Difference between change capture and Change apply? 20. Explain Compare Stage? 21. What is Surrogate key? 22. How to solve the problem of null values?

0 Answers IBM,

For more Database Management Interview Questions Click Here