import is different for different version of Oracle. I have this problem
before. To make this work:
- create a tnsname on box A , point to Box B.
- do import for box A to Box B unsing tnsname created above. This will
work.
- good luck.
ibm_97_at_yahoo.com wrote in message <83dijc$q7h$1_at_nnrp1.deja.com>...
>Box A: Oracle 8i for Solaris
>Box B: Oracle 8.0.5 for Linux (RedHat)
>
>I try to export a table from Box A, then import to Box B. In my 'exp'
>and 'imp' command I didn't assign the 'buffer' option. But the 'exp' is
>OK and the 'imp' failed, oralce compalins that 'SQL statement exceed
>buffer size'.
>
>But when I import to another Solairs Box(Oracle 8i)bu using the same
>export file (same option in 'imp' command as used in Linux), it's OK!
>
>Seems Linux and Solaris have some problems? Or Oracle 8i and Oracle
>8.0.5?
>
>Any suggestion? Thanks a lot!!!
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Fri Dec 17 1999 - 10:25:28 CST
