Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Sorry,sorry! Import and Export

Re: Sorry,sorry! Import and Export

From: TurkBear <johng_at_mm.com>
Date: Fri, 17 Sep 1999 20:56:09 GMT
Message-ID: <37e2a9d8.5044133@super.news-ituk.to>

There are 2 ways ( at least) that occur to me:

1:
Use the export utility on the Netware server where your DB is installed...either the command line one or ( if v8 still has it) ..load nwexport at a console prompt...Then use your NT's import utility to import it into that database...

2:
Create a database link in your NT database and create the table using create as select * from table_name_at_linknamecreatedabove.

This, for a large table, will not be quick and the constraints, indexes, etc will be lost...but it should work - if this is a one-time transfer, then recreate your constraints, etc on the NT database and move on...

Hope it helps...

Holger Glaeser <H.Glaeser_at_cis-Wurzen.de> wrote:

>It seems that my Netscape defaults to HTML-based postings, which
>is now disabled!
>So again my question:
>
>
>Hi,
>
>How can I export Data from Oracle 8.0.3 runing in Novel Netware 4.11 and
>import this dumpfile into Oracle 8.0.4 runing on Windows NT4 or Personal
>Oracel 8.0.4.
>
>On the normal way to use Exp80.exe, I get an error, that says, I would
>use the wrong system. I´m using
>exp80.exe from Oracle 8.0.4 on Windows NT.
>
>If there is another way, to copy Data between this Oracle-Server, please
>tell it. But
>it should not time-intensitive.
>
>Please Help.

  -----------== Posted via Newsfeeds.Com, Uncensored Usenet News ==----------    http://www.newsfeeds.com The Largest Usenet Servers in the World! ------== Over 73,000 Newsgroups - Including Dedicated Binaries Servers ==----- Received on Fri Sep 17 1999 - 15:56:09 CDT

Original text of this message

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