Hi ,

I tried using the following ..

Create table schema.NewTblName as (select * from schema.OldTblName) definition only;

It's creating only DDL but not the data..(If i remove "DEFENITION ONLY" it's giving error saying it needs that)
Is there any way that we can create table & have data for needed where conditions.

I will be very thank full if some body gives response.