OraFAQ Forum: Server Utilities » copy table with special char between oracle 8 and 10

Home » RDBMS Server » Server Utilities » copy table with special char between oracle 8 and 10

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

copy table with special char between oracle 8 and 10 [message #482957]

Wed, 17 November 2010 02:14

vdurieu
Messages: 4
Registered: December 2009

Junior Member

hello

I have to copy a table from oracle 8 to oracle 10
- dblink don't work between 8 - 10
- can I dump table ?
- when I try to use sqlload via TXT file, I have error messages due to a column containing 'special' caracters (\n,..) and line too long (splitted in several rows)

how can I do ?

Report message to a moderator