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
What are different clauses used in sql?
What is date functions?
What is rownum in sql?
What is the difference between having and a where in sql?
what are the different type of sql's statements ? : Sql dba
how is exception handling handled in mysql? : Sql dba
How do I add a database to sql?
what is the difference between rownum pseudo column and row_number() function? : Sql dba
How to avoid using cursors? What to use instead of cursor and in what cases to do so?
what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql
Can you have more than one key in a database?
what are the t string functions available in tsql? : Transact sql
Explain what is a database?
how would you enter characters as hex numbers? : Sql dba
What are the possible values that can be stored in a boolean data field?