DB Reorg with export & import

Hello Everyone,

I'm going to do a reorg for a 600MB database running on Ultrix 4.2 on a Vax3800. Since I don't have extra space, I need to a use a TLZ04 1.2 GB DATA tape drive as the media for export and import? Does any one how long it will take? I just need a rough estimate.

Also since I have some quite big tables (30+MB) in the DB, I DON"T want it to use the rollback segment in the System tablespace. But Oracle manual said you have to have one non-system rollback segment in the system tablespace if you have additional tablespaces. Can I bypass this constraint by creating (at least 3) more rollback segments in the, say "TEMP ROLLBACK" tablespace?

I also would like to hear if anything that I can tune to make the IMPORT faster. If I set COMMIT after after insert, instead of after full table insert, would there be a severe performance penalty. I'm thinking that, for large table insertion, COMMIT after every row insert will generate a log REDO log traffic. However, since each row is so small, the ROLLBACK segment block may be able to stay in cache, thereby eliminating disk IO for Rollback segments? Any comments?

Best regards. Received on Thu Nov 17 1994 - 08:29:52 CET