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

Question Posted / roopa

3 Answers
30592 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 are stored procedures in a database?

0 Answers

When we will denormalize data?

0 Answers

what are the two integrity rules used in DBMS?

0 Answers TCS,

What is tuple and attribute?

0 Answers

What is alternate key?

0 Answers

What is difference between database and schema?

0 Answers

What is metadata and why should I use it?

0 Answers

Does any body has ORACLE Certification latest Dumps on 1) Oracle - 10g DBA, 2) Oracle - 9i DBA, 3) Oracle - Internet Application Developer, 4) OCA, 5) OCP 8i to 10g DBA Upgrade, 6) Oracle - 10g,7) Other Oracle Certification, if any body has please send it to taruni_2k8@yahoo.com

0 Answers Oracle,

What is the data in a database?

0 Answers

What is flag in database?

0 Answers

What is the purpose of queries in a database?

0 Answers

What is difference between database and website?

0 Answers

For more Database Management Interview Questions Click Here