what is the fastest way to restore a db

From: Marco <marco.strullato_at_gmail.com>
Date: Thu, 18 Sep 2008 08:00:53 -0700 (PDT)
Message-ID: <b95d647a-5fe5-46e8-8210-b0b1175c0801@c58g2000hsc.googlegroups.com>

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 Received on Thu Sep 18 2008 - 10:00:53 CDT

This message: [ Message body ]
Next message: Shakespeare: "Re: tahiti.oracle.com"
Previous message: gazzag: "tahiti.oracle.com"
Next in thread: fitzjarrell_at_cox.net: "Re: what is the fastest way to restore a db"
Reply: fitzjarrell_at_cox.net: "Re: what is the fastest way to restore a db"
Reply: hpuxrac: "Re: what is the fastest way to restore a db"
Reply: joel garry: "Re: what is the fastest way to restore a db"
Reply: Michael Austin: "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