How do I take a backup of Stored Procedure in Oracle?
Answers were Sorted based on User's Feedback
Answer / roopa
SELECT
DBMS_METADATA.GET_DDL
('PROCEDURE','<PROCEDURE_NAME>','<SCHEMA_OWNER>')
FROM dual;
Is This Answer Correct ? | 15 Yes | 0 No |
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 |
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 |
What is Restricted Mode of Instance Startup ?
What is the role of database management system?
what is the index and synonym. i have the definitions ...can any one give me brief explanation.. with regards,
What do you mean by fill factor concept with respect to indexes?
what are the acid properties in dbms?
What is normalization and what are the different types of normalization?
What do you mean by durability in dbms?
What is 3nf in dbms?
What is executive plan?
explain the man feature of RDBMS ?
What are different type of normalization?
Explain meant by 3-tier architecture?