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
Printable View
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
Populate Underlying Tables. ( I assume the underlying tables of 2 views in different schema are of resp schmema )
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
yes those are the database views.
i want to have replica of the view in another schema
can u post the syntax .
do you know what is a view????? geeeez
To get a view definition:
Code:SELECT text
FROM user_views
WHERE view_name = [view_name];
boss my question is simple
I want to copy the view and its data , into another schema with the same what is the syntax ????
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?
I wonder, how can one demand answers, when one dosent know what a VIEW is...Quote:
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 think you may want to RTM...
If only I'd had the sense to stop here Pando :DQuote:
Originally posted by pando
do you know what is a view????? geeeez