Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2004

    Unanswered: Sharing of Data across applications

    Hi we have a Database up and Running. Which has some 450 tables with thousands of records. Now for another application, the data is required from our existing Database. But for the new application only selected table and columns are required, Not entire database.

    How to pass data from existing database into New application? Only 10-20 columns data from 4-5 tables is required into new application

    How to do this selective Export or any other way? Can you explain in detail.


  2. #2
    Join Date
    Mar 2002
    Reading, UK
    You have a number of choices.

    1) if the new app only does selects (no mods) then it could connect to your original database
    2) Have a job which drops all tables and then uses the exp/imp utilities to copy just those 5 tables
    3) Have a job which truncates the tables and then inserts the data (use APPEND hint) from those 5 tables
    4) Setup materialized views to copy the data over a regular intervals.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts