Home » RDBMS Server » Server Utilities » copy table with special char between oracle 8 and 10
icon5.gif  copy table with special char between oracle 8 and 10 [message #482957] Wed, 17 November 2010 02:14 Go to next message
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

Re: copy table with special char between oracle 8 and 10 [message #482960 is a reply to message #482957] Wed, 17 November 2010 02:23 Go to previous message
Michel Cadot
Messages: 68771
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
exp/imp, they are made for this.

Regards
Michel

Report message to a moderator

Previous Topic: data pump import order - causing constraint violation
Next Topic: Difference in exports, due to DIRECT=y
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Nov 29 14:29:18 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.