Interested to Buy Any Domain ? << Click Here >> for more details...
How do I take a backup of Stored Procedure in Oracle?
- 3 Answers
- 30450 Views
- I also Faced
- E-Mail Answers
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 |
Which database is best for storing large data?
What is database management definition?
What are functions in database?
What is the difference between horizontal and vertical partitioning?
What are different types of joins in sql?
What is join? Mention its types.
Define phantom deadlock.
what is ORACLE CLINICAL What are the uses of Oracle clinical
What is partial key?
What does partition mean in database?
when All datafiles related to a Tablespace are removed ?
What is the use of database management system?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
