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

Question Posted / roopa

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

What do you understand by fragmentation?

0 Answers

What's the difference between file and database?

1 Answers

Define database lock?

0 Answers

What is the role of database server in database management system?