DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 13

Thread: Copy A Veiw Data To Another View

  1. #1
    Join Date
    Jul 2002
    Posts
    32

    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

  2. #2
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    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"

  3. #3
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    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!

  4. #4
    Join Date
    Jul 2002
    Posts
    32
    yes those are the database views.

    i want to have replica of the view in another schema

    can u post the syntax .
    SHIVANAND HANUMANTAPPA

  5. #5
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    do you know what is a view????? geeeez

  6. #6
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    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!

  7. #7
    Join Date
    Jul 2002
    Posts
    32
    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

  8. #8
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    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"

  9. #9
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    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"

  10. #10
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    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
  •  


Click Here to Expand Forum to Full Width