Creating Duplicate Table From Existing Table [duplicate]

Question

Possible Duplicate:
SELECT INTO using Oracle

I have one table in my oracle database. I want to create one table with another name, but containing same data. How to achieve this ?

Answer 1

Use this query to create the new table with the values from existing table

CREATE TABLE New_Table_name AS SELECT * FROM Existing_table_Name;  

Now you can get all the values from existing table into newly created table.