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: URGENT: SUN to NT export

Re: URGENT: SUN to NT export

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Wed, 03 Nov 1999 18:49:43 +0800
Message-ID: <38201347.373@yahoo.com>


Jeff Kennedy wrote:
>
> I need help badly! I need to update a database on NT with data from a
> SUN. We have exported directly to tape on the SUN and now need to be
> able to import it on NT.
>
> Oracle says that you cannot import from tape on NT. Huh?! How could
> that possibly be?
>
> We have complete distributions of Oracle 8i. It's running on both
> platforms. Can this be done? It should be as simple as exporting
> from SUN and importing on NT but it doesn't seem to be so simple.
>
> Should we use backup and recovery manager? Backup from SUN and
> recover on NT?
>
> We could always do the kludge workaround: export to disk on SUN, ftp
> to an NT machine on our network, use NT Backup to put it on tape, use
> NT Backup on the target machine to restore the data to disk, then
> import from disk.
>
> Oh, yeah, the target machine is not on our network and the amount of
> data doesn't allow for ftp across the 'net. I am not a DBA and our
> dba's don't have an answer for this one.
>
> Thanks,
>
> ~JK

One work around would be:

HTH
--



Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Wed Nov 03 1999 - 04:49:43 CST

Original text of this message

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