very urgent
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: very urgent

  1. #1
    Join Date
    Jan 2001
    Posts
    10

    Red face

    can any body help me i had a query
    i want to updat tables in oracle 7.1.6 from oracle 8i database
    through database link
    can it be possible
    can any 1 give me solution
    or can it be done either way
    please revert
    thanx
    bakshi

  2. #2
    Join Date
    Jun 2001
    Location
    NJ
    Posts
    118
    Hi,
    Why can't you write a custom program in front-end tool like VB. Create a DSN one for each database and read from one and update to the other. I did the same way in converting from UNix to WIN NT when i moved the database from one to other.

    I think this will work.
    Thanks.
    Giri.

  3. #3
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    update tab1 t1
    set field1 = (select field1 from remote_tab1@dblink t2
    where t1.key = t2.key)

    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  4. #4
    Join Date
    Jan 2001
    Posts
    10
    do we need to change some parameters in init.ora or something
    can we update tables from 7.1.6 to oracle8i db

  5. #5
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    There is absolutely no need to change any init.ora parmeters .Just follow jeffs solution...........................it will work for you.it will work from any version to any version.........

    regards
    hrishy

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