covert data from one table to another

[karthickkuchanur]

hai all
i have the table name temp which contain the value,i want to copy the data from that table to new table i had tries but it throws error


CREATE TABLE TEMP1 AS(SELECT * FROM TEMP)

iam not have the table temp1,but the above query is working in oracle please help me

[ck9663]

hai all
i have the table name temp which contain the value,i want to copy the data from that table to new table i had tries but it throws error


CREATE TABLE TEMP1 AS(SELECT * FROM TEMP)

iam not have the table temp1,but the above query is working in oracle please help me

try:

select * into newtable from yourtemptable

-- CK

[karthickkuchanur]

try:

select * into newtable from yourtemptable

-- CK

Thank u sir,i have ececuted it and working fine