Re: what is the fastest way to restore a db

From: hpuxrac <johnbhurley_at_sbcglobal.net>
Date: Thu, 18 Sep 2008 15:16:35 -0700 (PDT)
Message-ID: <d90f6396-ed65-4a70-a606-c11adc3accc4@2g2000hsn.googlegroups.com>

On Sep 18, 11:00�am, Marco <marco.strull..._at_gmail.com> wrote:
> Hi all,
> what is the fastest way to restore an oracle db? I'm using impdp but
> it's really slow compared to other databases tools (for example db2
> restore command)
> the command I'm using is something like:
>
> impdp fx2/password_at_teng REMAP_TABLESPACE='FXTS':'FX2TS' directory=dump
> PARALLEL=2 dumpfile=fx_dump.dmp REMAP_SCHEMA=fx:fx2 NOLOGFILE=Y
> TABLE_EXISTS_ACTION=replace
>
> Regards,
>
> Marco Strullato

Well the fastest way is always to "not do it".

If you are importing a schema from one database to another I typically would think seriously about deleting then recreating the schema owner before doing an impdp.

Why don't you tell us exactly what you are doing and why and maybe we can give some more on target ideas. Received on Thu Sep 18 2008 - 17:16:35 CDT

This message: [ Message body ]
Next message: joel garry: "Re: Problems that can ocuur while upgrading from 9i 1o 10g"
Previous message: fitzjarrell_at_cox.net: "Re: Report what tables or columns being used and how often."
In reply to: Marco: "what is the fastest way to restore a db"
Next in thread: joel garry: "Re: what is the fastest way to restore a db"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message