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

Thread: Replication - not all columns

Threaded View

  1. 04-29-2008, 11:52 AM #1
    molonede
    molonede is offline Junior Member
    Join Date
    Dec 1999
    Location
    Cincinnati, Ohio USA
    Posts
    99

    Replication - not all columns

    We are needing to setup a replicated copy of one of our Oracle 10g databases to be used as a research/reporting database. One big limitation is that the research database will not have all the columns that the source database contains. For example, one of the tables that is to be replicated can not have the employee socail security # (ssn) column replicated. Since I may not have control over the research databsae, I don't even want to send the ssn to the replicated database, through archive logs or streaming. Keep in mind, some of the tables contain millions of rows.

    I am needing some advice on the best method for setting up this type of configuration.
    Last edited by molonede; 04-29-2008 at 12:00 PM.
    Doug
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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