Solved

utility

Posted on 2013-12-02
4
227 Views
Last Modified: 2013-12-13
Which utility is good to transport data from Linux to windows.....
0
Comment
Question by:dev_dba
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

930 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now