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

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the basic functions of a database?

557


Define database system.

645


how Data is stored in a file so that Direct Searching can be performed

676


Why do we use databases?

537


What is atomicity in dbms?

575






What are the three levels of data abstraction?

643


What are the Roles and responsibilities of database administrator?

2149


What do you understand by b-trees?

631


What is dbms pdf?

684


What are the five steps of data modeling?

545


How to pump the data from one database to another?

574


What is the license for clipper?

597


Single File Database: Develop a student record management program, which uses single file as its database. It is not supposed to create additional files at any part of the project and should never rewrite total content. It must be capable of storing 100000's of records. It should support variable length records to be added, deleted, modified, listed.

1888


What is database schema in dbms?

719


Explain what are triggers and rules?

587