Originally posted by shivanand
boss my question is simple
I want to copy the view and its data , into another schema with the same what is the syntax ????
I wonder, how can one demand answers, when one dosent know what a VIEW is...

I think you may want to RTM...