RE: HOW TO MAKE FAST EXPORT

From: Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
Date: Wed, 13 Feb 2002 18:30:35 -0800
Message-ID: <F001.0040EF5C.20020213180848@fatcity.com>

Use transportable tablespaces?

> -----Original Message-----
> From: Mark Leith [mailto:mark_at_cool-tools.co.uk]
>
> You could drop any indexes that are associated with the tables you are
> importing to - If you are simply exporting/importing (whilst
> no users are
> online). If you have any triggers that fire on insert in to
> the tables, then
> you could also disable those..
>
> Any thing else list?
>
> -----Original Message-----
> From: Seema Singh [mailto:oracledbam_at_hotmail.com]
>
> How to make import fast except BUFFER size increase and big
> rollback segment
> if I am reorganising the database.
>
Received on Wed Feb 13 2002 - 20:30:35 CST