Hi PIPO, 25th April 2001 19:20 hrs chennai

How about a situation where INDEXES are stored in another TS and other dependencies also in a same way.?

So i think it all depends on the size and storage the user has to plan am i right ?

But i do accept creating a table as select * from doesnt create the indexes as was in the original table.Which i didnt think over.

In this scenario once we had to create a table simillar to this structure (constraints etc)and moved the data's.The data volume was also huge.

Cheers

Padmam