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

Home -> Community -> Usenet -> c.d.o.server -> Re: how long to "transport tablespaces" with a read only tablespace?

Re: how long to "transport tablespaces" with a read only tablespace?

From: Daniel Morgan <dmorgan_at_exesolutions.com>
Date: Thu, 11 Jul 2002 15:53:11 GMT
Message-ID: <3D2DA9B6.30597D33@exesolutions.com>


Marc wrote:

> Before I start to waste a lot of R&D time, I was wondering if anyone can
> estimate how long it will take to move 2 1/2 gigs of read-only tables in 1
> tablespace to anther db.
>
> Detail:
> I a set of read only tables in 1 tablespace with their indexes that needs to
> be rebuilt a few times a day in a 24/5 database. These tables have no
> transactions other than my batch load. I was thinking of creating a staging
> copy of the production instance. Place the burden of rebuilding the tables
> in the staging. Then move the tablespace using the "transport tablespaces"
> method to the production instance. Can anybody know how long it can take to
> move 15 tables. I can not have a user get an error or wait more than 1
> minute(and 1 minute is to long). I also have stored package that are tied
> to these tables.
>
> Can anyone help?

How fast is your network at copying 2.5 GB? Then add a few minutes.

But I am rather confused by your statement that indexes need to be rebuilt a few times a day? Why?

Daniel Morgan Received on Thu Jul 11 2002 - 10:53:11 CDT

Original text of this message

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