Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> Re: copying tables to another db, oracle 9.2

Re: copying tables to another db, oracle 9.2

From: Carel-Jan Engel <>
Date: Tue, 21 Mar 2006 17:49:26 +0100
Message-Id: <>


Trica wrote:

> I've created a report user and throttled
> resources for this user, but my goal is to restrict all
> non-application access to the production database. I would like to
> automate the copy the reporting data to a dedicated report database on
> another host, preferably daily.

I didn't understand the varying userbase was part of the problem: Tricia likes to separate managers running reports from the 'real' application. She will correct me if I'm wrong. With my understanding of the probem a read only standby can help to accomplish this task. If you have a dataset that needs to be refreshed once a day, and it is queried for the rest of the day, you can do that with a read-only standby. The read-onloy standby can use the (locally managed) temporary tablespace if queries are getting big.

A real-life example: One of my customers runs their application web-based on an ASP-basis. It's HR/recruitment stuff. Every now and then one of their users throws away resumes of candidates, or vacancies, or whatever, and then discovers it was the wrong item that was deleted. They will call the helpdesk then, and ask to restore the data. The helpdesk can do this pretty fast through a database-link to their standby database, that is refreshed daily, but with a 2-day lag. Pretty much the same way as I explained it to Tricia.

Best regards,

Carel-Jan Engel

If you think education is expensive, try ignorance. (Derek Bok) ===

On Tue, 2006-03-21 at 11:04 -0500, Ray Stell wrote:

> On Tue, Mar 21, 2006 at 11:39:21AM +0100, Carel-Jan Engel wrote:
> > You might consider setting up a
> > standby database (other members of the list were probably wondering why
> > it took me so long before coming up with this ;-).
> I thought the proposed problem implied a varying user base between prod
> and target dbs. Can you do that with a dataguard/readonly standby?
> --

Received on Tue Mar 21 2006 - 10:49:26 CST

Original text of this message