write the Sql query for creating database backup?

Categories >> Software >> Databases >> SQL PLSQL
Suggest New Category

Question Posted / samplestudy

7 Answers
20992 Views
TCS, I also Faced
E-Mail Answers

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