Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Sorry,sorry! Import and Export
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
![]() |
![]() |