Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Nightly Incrementals for a specific user?

Re: Nightly Incrementals for a specific user?

From: Mladen Gogala <mgogala_at_verizon.net>
Date: Tue, 24 Oct 2006 01:00:45 -0400
Message-id: <1161666045l.3023l.0l@medo.noip.com>

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
Received on Tue Oct 24 2006 - 00:00:45 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US