From: news.hans@telus.net   
      
   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   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)