Re: Data not importing correctly
Date: Mon, 04 Oct 2004 12:42:43 GMT
Message-ID: <7zb8d.20310$223.5959_at_edtnps89>
>
> As I said I'm new to the Oracle world. I hav TOAD on both the
> 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