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 t
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 A
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?
-
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 L
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 y
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
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 s
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 (whi
_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 els