DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Schema A

  1. #1
    Join Date
    Jul 2001

    Schema A

    I have a database with 2 schemas
    Schema A and B

    There is a table in A which has 3 columns which also exist in a table in B. I want to perodically update the data in A into the 3 cols in B
    what is the best way to do this.

    Export Import is not an option.

    I was thinking of creating a private db link on schema A poiting at Schema B and just rightign a simple update script to update the 3 cols and then just scheduling that update script, Is there a better way to do this e.g a dbms package!

    Thanks in advance

  2. #2
    Join Date
    May 2002
    if both the tables are in the same database then u can avoid dblink .

    just give a select and update grant on table from schema A to Schema B . then create a simple update statement in a package and schedule this package through dbms_job.submit at the frequency u wanted.
    siva prakash

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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.