Re: backup and restore a big table

From: Stephen Ashmore <sashmore_at_neonramp.com>
Date: Sun, 12 Aug 2001 09:23:48 -0000
Message-ID: <tnd4do3pcclp83@corp.supernews.com>

Import/export is always a good method.
Howver when you import the table it is usually much faster to drop all of the indexes prior to running the import then recreate them after.

If you have enough disk space in your database you can also create a copy of your
table and use a direct load insert into your working table where ever you need it reloaded.

Stephen C. Ashmore
Brainbench MVP for Oracle Administration http://www.brainbench.com

"Cheong" <leslie_hk_at_hotmail.com> wrote in message news:3b757337_at_newsgate.imsbiz.com...
> Hi all,
>
> For our testing environment, I always need to backup and restore a big
> table. Can anyone tell me which is the best method to do this?
>
> Thanks in advance
>
> Antony
>
>
Received on Sun Aug 12 2001 - 04:23:48 CDT