Re: Copy a schema without using EXP?

From: JustAnotherDBA <jadba_at_bellsouth.net>
Date: Sat, 1 Mar 2003 12:48:57 -0600
Message-ID: <p%68a.41992$sA1.12394@fe03.atl2.webusenet.com>

You should be able to exp the server user data in client server mode, depending on versions. We really need to know your client and server versions.

Of course, exp/imp on the server itself (if possible) is the best because of less issues with different versions on client and server and it performs better (especially if to a local disk on the server).

Note: We did have a problem running exp or imp (I can't remember) using 8.1.7 on client against 8.1.6 server. This would normally work and this is an odd case. But, I did see a workaround/fix in Metalink. However I never applied it because we just recently upgraded our server to 8.1.7 and no longer have the problem.

"Harry" <a_at_abc.com> wrote in message
news:qv28a.10663$U13.85378238_at_news-text.cableinet.net...
> Using Oracle 8i on windows 2000 (sp3)
>
> I want to copy a Users schema in its entirety from another oracle database
> running remotely in to my local one. I have a valid user account in that
> database for the schema owner but because EXP only seems to work on the
> current database I can't do an EXP then IMP
>
> Is this possible?
>
> thanks
>
> harry
>
>
Received on Sat Mar 01 2003 - 12:48:57 CST