write the Sql query for creating database backup?
Answer Posted / gourvendra singh
if you need to take tha backup of the database on ur hard
disk then u can use the following query:
exp userid=system/manager@orcl file=location\abc.dmp full=y
log= abc
| Is This Answer Correct ? | 23 Yes | 4 No |
Post New Answer View All Answers
How can you tell the difference between an index and a view?
How exception is different from error?
Is natural join and inner join same?
What is the purpose of a secondary key?
Where do we use pl sql?
What is the use of %rowtype?
How to set up sql*plus output format in oracle?
Write a program that shows the usage of while loop to calculate the average of user entered numbers and entry of more numbers are stopped by entering number 0?
What is replication id?
How to write a query to show the details of a student from students table whose
How do I count duplicates in sql?
What is data type in sql?
Which tcp/ip port does sql server run on? How can it be changed? : Sql dba
what is the use of set statement in tsql? : Transact sql
1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins