Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Data copy utility?
Sure, Oracle has replication. However, in this case I would suggest a
dblink to the other database and then a materialized view that
massages the data however you like and then populates it to the
materialized view as often as you define the update interval. If you
need to do DML actions on the data then create a procedure that
creates the table for you using the create table example as select
blah from production. Check out the execute immediate command from
within PL/SQL.
I guess what you are really trying to do is mask the production data from development. In that case, you might write a function that takes the column data and randomly scrambles it. Then in the select from production, wrap each column with the function. In this case, have the dblinks owned by a different user than the developers, and have that dblink user create the developer's extract data. That way the developer's only seeing the scrambled data.
There are also many tools like Informatica, Embarcadero's DT/ Studio, DataJunction that provide more bells and whistles for doing data Extraxtion, Transformation, and Loading (ETL). You might also consider a lower end tools that does some of the same things like Microsoft's DTS (Data transformation services) and a trial of Oracle Data Warehouse builder...
However, I think the first solution will meet your needs.
Mitch
stinky <stinky_at_stinkytoes.org> wrote in message news:<3C9A87DC.BFFA9C58_at_stinkytoes.org>...
> Are you suggesting that Oracle doesn't have a tool to handle replication?
> Wow, DB2 has had that forever. If true, that's a huge negative for Oracle.
>
>
>
> koert54 wrote:
>
> > it'll be way quicker to write it yourself using whatever programming
> > language than finding a tool and configuring it ....
> >
> > "Chuck" <chuck_hamilton_at_yahoo.com> wrote in message
> > news:a7dg1p$kj7q5$1_at_ID-85580.news.dfncis.de...
> > > -----BEGIN PGP SIGNED MESSAGE-----
> > > Hash: SHA1
> > >
> > > I'm looking for a data copying utility that will extract data from a
> > > production database and copy it to a development database. The catch
> > > is I want it to change data is it copies. Names, social security
> > > numbers, and salaries for instance must all be changed before writing
> > > them to the development database. Can anyone recommend such a tool?
> > >
> > > -----BEGIN PGP SIGNATURE-----
> > > Version: PGPfreeware 7.0.3 for non-commercial use <http://www.pgp.com>
> > >
> > > iQA/AwUBPJpEIGm5A4kkb4ZsEQIGTwCgrISgHv4KAxlBD0K16dkAN74DbgIAniTb
> > > ML2Y/auBVRijVNxDByuIcJvL
> > > =vdYP
> > > -----END PGP SIGNATURE-----
> > >
> > >
> > >
Received on Fri Mar 22 2002 - 07:57:47 CST