Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> Database Management
  2. Suggest New Category

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

Question Posted / roopa

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

Do we consider null values the same as that of blank space or zero?

0 Answers  

What is the best free database?

0 Answers  

How to detect applications and users that hold transactions open too long?

0 Answers  

Define sub-query.

0 Answers  

What is the use of NOARCHIEVELOG parameter in Database?

1 Answers  

difference between generalisation,specialisation and aggregation? with examples.

0 Answers  

What are the features of database language?

0 Answers  

What are indexes ? What are the advantages ? (Phone Screen)

1 Answers   NetApp,

Explain the term ‘relations’?

0 Answers  

Explain the different types of languages that are available in the dbms?

0 Answers  

Is it possible to Disable the Parameter form while running the report ?

1 Answers  

What's the difference between 'union' and 'union all' ?

0 Answers  

For more Database Management Interview Questions Click Here
Categories