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: Copy a schema without using EXP?

Re: Copy a schema without using EXP?

From: Harry <a_at_abc.com>
Date: Sun, 02 Mar 2003 18:12:00 GMT
Message-ID: <QPr8a.12085$hs.96585969@news-text.cableinet.net>


Thanks chaps, works perfectly!

"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 Sun Mar 02 2003 - 12:12:00 CST

Original text of this message

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