Re: Nightly Incrementals for a specific user?

On 10/24/2006 12:38:27 AM, laura pena wrote:
> 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
> tablespaces).
>
> 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.
>

Laura (is it Lizz or Laura? Your email says "Laura" and your signature says "Lizz") you have essentially two options:
1) Materialized views
2) Streams replication.

I would recommend streams replication as I find it more reliable and it consumes less space. It consumes less space because with MV's, you still have to get the content from the MV into tables, so you consume space for both MV's and tables.

-- 
Mladen Gogala
http://www.mladen-gogala.com

--
http://www.freelists.org/webpage/oracle-l