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

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 - 09:16:32 CST