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

Question Posted / roopa

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

describe middleware applications that ease the connection of databases to web?

0 Answers

How many database systems are there?

0 Answers

Define sub-query.

0 Answers

What is tuple with example?