"CREATE a table from another table" issue

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

"CREATE a table from another table" issue

Author

Topic

allen_k85
Starting Member

3 Posts

Posted - 2009-12-10 : 07:40:39

hey everyone,
below is my query..

create table newtablename as
select * from oldtablename
tablespace temp

in which scenario, the above statement wont work in oracle..would be grateful if anyone can reply to this.

Allen

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2009-12-10 : 07:43:51

This is a SQL Sever forum, but anyway.. To do this in SQL Server:


select * into newtablename
from oldtablename

In Oracle, ask on an oracle forum.

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2009-12-10 : 07:44:12

quote:
Originally posted by allen_k85

hey everyone,
below is my query..

create table newtablename as
select * from oldtablename
tablespace temp

in which scenario, the above statement wont work in oracle..would be grateful if anyone can reply to this.

Allen

This site is for MS SQL Server
Post your question at www.orafaq.com

EDIT :

Madhivanan

Failing to plan is Planning to fail

allen_k85
Starting Member

3 Posts

Posted - 2009-12-10 : 07:54:57

thanks for the oracle link...tk

Allen

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources