External Table
We have an external table say ext1.
I have created another table say ext2 as "create table t2 as select * from ext1"
Then i have dropped ext1 and renamed t2 as ext1
Now the table ext1 is not an external table. How to make this table as external table.
Thanks,
Sathya.S