Re: Fast schema duplication
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Wed, 18 Mar 2009 11:49:05 +0000 (UTC)
Message-ID: <gpqn3h$loo$2_at_solani.org>
On Wed, 18 Mar 2009 09:32:28 +0100, News.Individual.NET wrote:
Date: Wed, 18 Mar 2009 11:49:05 +0000 (UTC)
Message-ID: <gpqn3h$loo$2_at_solani.org>
On Wed, 18 Mar 2009 09:32:28 +0100, News.Individual.NET wrote:
> Hi all,
>
> I've to duplicate frequently a schema. Usually I do it with exp/imp, but
> I'm looking if there's a PL/SQL package make me able to do it direcly
> from SQLPLUS and maybe to make my customer to do it without call me ...
>
> Thanks
> Ste
Yes, there is such a package. It's called DBMS_DATAPUMP. It's documented
here:
http://download.oracle.com/docs/cd/B19306_01/server.102/b14215/dp_api.htm
This package works on all versions that are currently supported.
-- http://mgogala.freehostia.comReceived on Wed Mar 18 2009 - 06:49:05 CDT