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

From: Marc <Marc-Weinstock_at_si.rr.com>
Date: Thu, 11 Jul 2002 01:52:03 GMT
Message-ID: <7x5X8.59111$Wi.17271585@twister.nyc.rr.com>

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? Received on Wed Jul 10 2002 - 20:52:03 CDT