Stephane,
I know one case, in which documents need to be put from an intranet
database to an extranet database. For historical reason, the documents
are stored as LONG RAWs in the source (8.0.5) database, BLOBs in the
(newer) 8.1.5 target database.
Snapshots were ruled out because they 'pull' the data and would have
forced the extranet database to see the intranet one. Physical copy
(clone) was ruled out because all the intranet data needs not be stored
to the extranet database. exp/imp was ruled out because of the time
involved (to make matters worse there is also Context/Intermedia
indexing of documents). Transportable tablespaces might have been an
option with other versions but we didn't have to contemplate it.
Currently, there is a program running on the intranet host which
truncates, then does an 'INSERT ... SELECT ..' into all the tables bar
one (the one which contains the documents), then looks for the most
recent document in the extranet database and inserts all the newer
documents from the intranet database, converting from LONG RAW to BLOB
in the process (the Oracle conversion function comes with 8.1.6 ...). It
takes about 10 minutes. Not fully satisfactory, we intend to replace it
with something better in the future, but it works.
--
Regards,
Stephane Faroult
email: sfaroult_at_oriolecorp.com
Oriole Corporation
Voice: +44 (0) 7050-696-269
Fax: +44 (0) 7050-696-449
Performance Tools & Free Scripts
------------------------------------------------------------------
http://www.oriolecorp.com, designed by Oracle DBAs for Oracle DBAs
------------------------------------------------------------------
>
>
> I've asked this question yesterday and got no answers.
> This is the second run. I'm sure sombody has a dss
> application accessed by extranet.
>
> > Hi all,
> >
> > By the end of the year we'll have a small
> > datawarehouse in production. It will be accessible
> > internally but also by our extranet. The extranet
> > team
> > wants a second copy of the datawarehouse only for
> > the
> > extranet, so intruders have no physical access to
> > the
> > datawarehouse number 1.
> >
> > We may get the budget to clone all databases being
> > accessed by the extranet.
> > Anydody doing that ?
> >
> > TIA
> >
> > =====
> > Stephane Paquette
Received on Thu Oct 12 2000 - 04:43:05 CDT
