Re: Data not importing correctly

Andrew Lowe wrote:

>
> As I said I'm new to the Oracle world. I hav TOAD on both the

No worries. There are reasons for using exp and there may be some for avoiding it. Wanted to verify first.

> clients
> machine and my own and it makes life a lot easier for me, eg SQL Plus Vs
> TOAD. When I was at my clients office, my concern was that their setup of
> Oracle 9i running on Solaris, ie 64 bit on a SPARC CPU, would cause binary
> problems when trying to load data into my setup, 9i on Win2000, ie 32bit
> on Intel, hence the "text way".

Assuming you want ALL the table data, Oracle provides a pair of utilities to export data from a database and import that same data. There are preconditions (version, char set), but in general these utilities will help you ensure you get the data across properly regardless of OS.

You want to run exp for a table using the table owner on the solaris box. Then imp on windows. (Command line utilities)

Both commands respond to parameter 'help=Y' to provide syntax - should be enough to help. Both are very flexible and are fully described in the Utilities manual at http://tahiti.oracle.com

HTH
/Hans Received on Mon Oct 04 2004 - 14:42:43 CEST