There's a (somewhat dated) tip on my site under the
Tuning link about things you can do to make imports
faster
hth
connor
--- Mark Leith [EMAIL PROTECTED] wrote:
_make_import_faster = true ;)
You could drop any indexes that are associated with
the tables you are
importing to - If you are
Hi Jacques,
I used transportable tablespace to do this. It is fast, however, it
didn't serve the reorg purpose. It rebuild all the objects exactly as
same structure as original.
Joan
Jacques Kilchoer wrote:
Use transportable tablespaces?
-Original Message-
From: Mark Leith
Title: RE: HOW TO MAKE FAST EXPORT
Check the Utilities manual for the
DIRECT=Y parameter
Matt Adams - GE Appliances - [EMAIL PROTECTED]
I've been so downhearted ever since the day we met.
You're love ain't nothin' but the blues. Baby how blue can you get?
- Jonny Moore
If you know of a way to set direct=y with an import I'd love to hear it :)
However I suppose that if there are some especially large tables they could
be spooled to a text file and loaded with a sql loader script.
Jay Miller
-Original Message-
Sent: Thursday, February 14, 2002 10:34
Title: RE: HOW TO MAKE FAST EXPORT
You're right (someone else had made the same comment.) I missed the word reorganising in the original e-mail. My apologies.
-Original Message-
From: Joan Hsieh [mailto:[EMAIL PROTECTED]]
I used transportable tablespace to do this. It is fast
_make_import_faster = true ;)
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
Title: RE: HOW TO MAKE FAST EXPORT
Use transportable tablespaces?
-Original Message-
From: Mark Leith [mailto:[EMAIL PROTECTED]]
You could drop any indexes that are associated with the tables you are
importing to - If you are simply exporting/importing (whilst
no users
1. Drop indexes, disable constraints, disable triggers.
2. Do not import indexes.
3. Turn off analyizing of objects.
4. Increase buffer size to about 5-10MB. More than that may not help.
5. Keep users out.
6. Turn off Archive log mode.
7. Do not use that feedback thingy.
8. Increase redo log
Is this solve fragmentation problem of tablespace?
Thx
-sEEMA
From: Jacques Kilchoer [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: HOW TO MAKE FAST EXPORT
Date: Wed, 13 Feb 2002 18:08:48 -0800
Use transportable tablespaces