Nightly Incrementals for a specific user?

  • From: laura pena <lizzpenaorclgrp@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Mon, 23 Oct 2006 21:38:27 -0700 (PDT)

Looking for recommendations here. 

I need to export a user from an instance (probably exp
maybe RMAN) then apply changes made from that user to
a new database on a nightly basis. The reason I only
want a single user is we currently share an instance
with another application. In addition, this user has
it's own tablespaces (there are no sharing of

What are dbas recommendation on how to perform this
sort of task?

In summary we would like to perform a full backup of
just a user once, then apply incremental of just that
user to a new system on a nightly basis.

We are running Oracle on solaris going to
oracle on linux.

Our user (schema) is fairly small around 1G in size.
Inserts are about 40k inserts, maybe 2,000
updates/deletes a day. There are around 40 tables in
this schema. The other users in this database are the
large ones and we are not interested in migrating
these other users.

Thanks in advance for your help and advice.


Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 

Other related posts: