yes those are the database views.

i want to have replica of the view in another schema

can u post the syntax .