create table backup as select * from user_tables; create table backup1 a

write the Sql query for creating database backup?

Question Posted / ganesh

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

Please Help Members By Posting Answers For Below Questions

How to write pl sql program in mysql command prompt?

1158

what happens if null values are involved in expressions? : Sql dba

1089

How do sql triggers work?

1090

Can you rollback after commit?

1046

Can we join tables without foreign key?

1005

What is difference sql and mysql?

1034

what is the difference between truncate and delete statement? : Transact sql

1116

Which is better stored procedure or query?

1015

Why is a primary key important?

1103

How do I create a memory optimized filegroup?

1010

What is sqlite format?

1257

Is it possible to create startup or shutdown trigger for on-schema?

1090

what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba

1064

What are local and global variables and their differences?

1135

Is sql the best database?

1020