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

Question Posted / roopa

3 Answers
30272 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

Could you give me an example how, where I code checkpoint and restart. I need and example

0 Answers

Explain the syntax of named procedure?

0 Answers

What are the characteristics of dbms?

0 Answers

Can we save image in database?