write the Sql query for creating database backup?

Answers were Sorted based on User's Feedback



write the Sql query for creating database backup?..

Answer / 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

write the Sql query for creating database backup?..

Answer / k.l.rajesh babu

BACKUP DATABASE DATABASE_NAME TO DISK='C:\BackupDB\DB.bak'

Is This Answer Correct ?    16 Yes 2 No

write the Sql query for creating database backup?..

Answer / suresh

BACKUP DATABASE DATABASE_NAME TO DISK='C:\BackupDB\DB.bak'

Is This Answer Correct ?    8 Yes 1 No

write the Sql query for creating database backup?..

Answer / vikneswaran

SELECT column_name(s)
INTO new_table_name
FROM old_tablename

Is This Answer Correct ?    3 Yes 8 No

write the Sql query for creating database backup?..

Answer / rk

we can do it from user_tables

like

select table_name,tablespace_name from user_tables;

Is This Answer Correct ?    5 Yes 12 No

write the Sql query for creating database backup?..

Answer / ganesh

create table backup as select * from user_tables;

create table backup1 as select * from user_source;

Is This Answer Correct ?    4 Yes 13 No

write the Sql query for creating database backup?..

Answer / manojbatra071

create table backuptablename as select * from originaltablename;

Is This Answer Correct ?    3 Yes 13 No

Post New Answer

More SQL PLSQL Interview Questions

Do we need commit after truncate?

0 Answers  


How can you fetch common records from two tables?

0 Answers  


How do you display "13th of November, 17 days left for month end" without hardcoding the date.

3 Answers  


Why do we use joins in sql?

0 Answers  


What are the possible values for the boolean data field?

0 Answers  


In pl/sql, what is bulk binding, and when/how would it help performance?

0 Answers  


What are inner outer left and right joins in sql?

0 Answers  


how can we take a backup of a mysql table and how can we restore it. ? : Sql dba

0 Answers  


what is the difference between delete and truncate commands? : Sql dba

0 Answers  


Does oracle roll back the transaction on an error?

0 Answers  


what is 'force view'?

3 Answers   Cap Gemini, SPIC,


How to run sql*plus commands in sql developer?

0 Answers  


Categories