Re: create table as select ... with index (copy a table structure)

within your constraints: no
of course you could run Toad create the script for your source table and edit it to reflect the new table name, but I have a feeling that's also too much effort.
The only other solution looks like submitting an enhancement request.

Regards,

Sybrand Bakker, Oracle DBA

"bernhard labus" <bernhard.labus_at_home.ins.de> wrote in message news:3a4a0740$0$8780$4dbef881_at_businessnews.de.uu.net...
> Hello everybody
>
> it is easy to create a table B as copy of A (only structure, no data):
> "create table B as select * from A where rownum=0;"
>
> **But** :
> with the statement above I get **no indices** for the new table B.
>
> ??
> Is it possible to create table B as copy of A with indices?
> Not wanted:
> - export-import / long statements
> Wanted:
> something *like* : "create table B as select * from A where rownum=0
> including indices"
>
>
>
>
Received on Wed Dec 27 2000 - 10:27:21 CST