Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Traditional Full Database Export\Import in 10g

Re: Traditional Full Database Export\Import in 10g

From: hpuxrac <johnbhurley_at_sbcglobal.net>
Date: 8 Sep 2006 16:56:17 -0700
Message-ID: <1157759777.104208.73500@b28g2000cwb.googlegroups.com>

Michael42 wrote:
> Hello,
>
> The DataPump is a great tool and I am migrating all my jobs to use it
> in my 10g databases.
>
> I have one job that I must rely on a traditional full database export
> (from production) and a full database import (to a development system).
> Usually when I perform a full database import in 9i I'll drop all
> users except sys,system and dbms.
>
> Is there anything I should know when refreshing a database using full
> database export\import in Oracle 10g?
>

I haven't tested that yet in 10g but that is my understanding.

Data Pump is new and "recommended" but for compatibility purposes, the old export/import is still going to be around for "a while" ( aka maybe forever ). Received on Fri Sep 08 2006 - 18:56:17 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US