-
Copy A Veiw Data To Another 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
SHIVANAND HANUMANTAPPA
-
Populate Underlying Tables. ( I assume the underlying tables of 2 views in different schema are of resp schmema )
funky...
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
-
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
Jim
Oracle Certified Professional
"Build your reputation by helping other people build theirs."
"Sarcasm may be the lowest form of wit but its still funny"
Click HERE to vist my website!
-
yes those are the database views.
i want to have replica of the view in another schema
can u post the syntax .
SHIVANAND HANUMANTAPPA
-
do you know what is a view????? geeeez
-
To get a view definition:
Code:
SELECT text
FROM user_views
WHERE view_name = [view_name];
Jim
Oracle Certified Professional
"Build your reputation by helping other people build theirs."
"Sarcasm may be the lowest form of wit but its still funny"
Click HERE to vist my website!
-
boss my question is simple
I want to copy the view and its data , into another schema with the same what is the syntax ????
SHIVANAND HANUMANTAPPA
-
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?
Sanjay G.
Oracle Certified Professional 8i, 9i.
"The degree of normality in a database is inversely proportional to that of its DBA"
-
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...
funky...
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
-
Originally posted by pando
do you know what is a view????? geeeez
If only I'd had the sense to stop here Pando
Jim
Oracle Certified Professional
"Build your reputation by helping other people build theirs."
"Sarcasm may be the lowest form of wit but its still funny"
Click HERE to vist my website!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|