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

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