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

Write an sql query to select all records from the table?

749

What is scalar and vector?

718

how to return query output in html format? : Sql dba

843

difference between anonymous blocks and sub-programs.

817

What does where 1/2 mean in sql?

750

What is primary key and unique key?

756

What are the various restrictions imposed on view in terms of dml?

689

How does postgresql compare to oracle/db2/ms sql server/informix?

767

What is the difference between joins?

725

Define select, insert, create, delete, update, drop keywords

776

What are the qualities of 2nf?

747

What is rownum in sql?

758

what is single byte over head in oracle..?

2080

How does one use sql*loader to load images, sound clips and documents? : aql loader

877

What does joining a thread mean?

750