Solved

utility

Posted on 2013-12-02
4
229 Views
Last Modified: 2013-12-13
Which utility is good to transport data from Linux to windows.....
0
Comment
Question by:dev_dba
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 
LVL 10

Expert Comment

by:HuaMinChen
ID: 39691673
You can export DMP from Oracle DB, within Linux, then import it to Oracle DB, that resides in Windows server. The same DMP file is readable/transferrable within Linux and Windows.
0
 
LVL 37

Expert Comment

by:Geert Gruwez
ID: 39692294
Ftp
File Transfer Protocol
0
 
LVL 23

Accepted Solution

by:
David earned 500 total points
ID: 39692613
Data as in a query's result set?  From the target database, create a DBLINK to the remote; then massage the inserts however you wish.  Create Table As Select .... works as well.

If you need all the tables within a tablespace, a tablespace can be transported intact between instances.

So, what exactly do you need to accomplish?
0
 

Author Closing Comment

by:dev_dba
ID: 39717633
Thanks
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question