Copy A Veiw Data To Another View

[shivanand]

folks

schema a

VIEW - employee - 100 records

schema b

VIEW - employee - 2 records

now i want to have 100 receords for view employee IN SCHEMA B

how can i do that in sql command

thanks in advance

[abhaysk]

Populate Underlying Tables. ( I assume the underlying tables of 2 views in different schema are of resp schmema )

[jovery]

What do mean by VIEW, are you talking about a database VIEW in which case either the VIEW is defined differently in each schema, so simply recreate the VIEW.

Alternativly there are access controls which stop userB accessesing some of the rows in the table, so you would need to remove those.

Regards

[shivanand]

yes those are the database views.

i want to have replica of the view in another schema

can u post the syntax .

[pando]

do you know what is a view????? geeeez

[jovery]

To get a view definition:

SELECT text
FROM user_views
WHERE view_name = [view_name];

[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 ????

[SANJAY_G]

It's not that simple. If you read the concept you will know that views don't store any data physically (unless created as materialised views) so what data you want to transfer?
View are just a select statement stored in the dictionary and Jim gave you the query on how to see that SELECT statement.
Is it a simple answer or you are still looking for a simpler one?

[abhaysk]

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...

[jovery]

Originally posted by pando
do you know what is a view????? geeeez

If only I'd had the sense to stop here Pando