Snapshot of Data on another database

[ronnie]

Hi,

We have 2 databases one internal OLTP database and another external
which our clients access.

We want to have a snapshot of the internal database on our external
database so that our clients can have read only access to the external
database.

I came up with the following solutions

Export the whole schema and import it into the external database. But
this has turned out to be a pain as I will have to drop the schema and
recreate it and then import the tables.

Implement views on the external database for each and every table in
the internal database, but this will increase the load on our internal
database and more important since our internal database is licensed on
Named user plus, every client of ours that connect to our database
will be a Named User. (Our external database is licensed on number of
processors but since views will access the internal database through
database links oracle treats these as Users)

Is there any other better solution to do this.

Maybe Replication....

Please suggest.

Thanks
Ron

[rad_jen]

Consider setting up Logical Standby.

[kris109]

How big is the database?

You say you need a snapshot of the 'database' by exporting 'whole schema'? Do you need the entire database or just one schema?

[gbrabham]

snapshot replication is not a bad idea in this case ... Will the
external database be "read-only" ? If so, then nonupdateable
snapshots is probably a good way to go...

HTH
Gregg

[pando]

you database must be tiny to make you consider export/import as an option to take snapshots of data

read about read-only snapshots

[ronnie]

Hi,

I just need a snapshot of one particular schema and the size is somewhere around 10Gigs and growing by around 200-300 MB pe month.

Where do I find good documentation and information on Read only snapshots. Its basically replication isnt it. How complicated wou;d it be to implement this.

Thanks
Ron

[slimdave]

I would have a read of the Advanced Replication guide -- it contains a lot more information than you actually need, but you'll probably be a lot more comfortable with the environment afterwards.

Anyway, it's only 360 pages.

[ronnie]

Thanks slimdave,

Whs the author for the book.

Thanks
Ron

[hacketta1]

I think Slimdave might be refering to this, or the equivalent for your Oracle version. Don't quote me though!