Oracle FAQ

Your Portal to the Oracle Knowledge Grid

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US

Home -> Community -> Usenet -> c.d.o.server -> Re: how to create a duplicate table using sql

Re: how to create a duplicate table using sql

From: Bricklen <bricklen_at_zyahoo.zcomz>
Date: Tue, 07 Dec 2004 23:36:07 GMT
Message-ID: <H7rtd.821$6f6.101@edtnps89>

db2group88_at_yahoo.com wrote:
> no, i can't insert data when i create the table, i just need to create
> an empty tables . thanks
>

create table t1 as select * from t2 where 1=0; Received on Tue Dec 07 2004 - 17:36:07 CST

This message: [ Message body ]
Next message: Howard J. Rogers: "Re: type of striping"
Previous message: Alex Filonov: "Re: Oracle read consistency *inside*a transaction"
In reply to: db2group88_at_yahoo.com: "Re: how to create a duplicate table using sql"
Next in thread: Howard J. Rogers: "Re: how to create a duplicate table using sql"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US