sql temt table error

[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 but not in sql please help me

[chaarmann]

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 but not in sql please help me

Can you please list error message?

Maybe you dont have the same privileges ( i mean you are not allowed to create tables if you submit through user from your "sql" instead from another user in "oracle"? (I really wondering what's the meaning of these strange names here. is "sql" your application, and "oracle" your Toad?)

Also you should make a space between "AS" and "(". You can also leave out brackets at all.

[debasisdas]

What is the error message ?