Re: "Best" way to copy schema data to another DB

  • From: Jared Still <jkstill@xxxxxxxxx>
  • To: mark.teehan@xxxxxxxxxxxxxxxxx
  • Date: Wed, 14 Apr 2010 10:58:34 -0700

On Tue, Apr 13, 2010 at 11:57 PM, Teehan, Mark <
mark.teehan@xxxxxxxxxxxxxxxxx> wrote:

>
> Slightly OT but another major difference between exp and expdp: you need
> database server access for expdp.
>

That can be worked around if the environment allows it.

The method I use:
Create a directory on our network for the files in question
Mount this on our linux server with 'mount -t cifs ...'

Server access then not needed for expdp/impdp.

That's one method, there are other ways to do it.

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Oracle Blog: http://jkstill.blogspot.com
Home Page: http://jaredstill.com

Other related posts: