SQL Loader

DBA Geral (instalação, configuração do banco, scripts do Sql*Plus, shell scripts, batch scripts, etc...)
Post Reply
Loader
Rank: Estagiário Júnior
Rank: Estagiário Júnior
Posts: 1
Joined: Thu, 28 Jun 2007 3:26 pm
Location: São paulo

Personal, I have the following problem:

I am running the SQL Loader from a file.
However, I have a record with more than 4000 characters and I am trying to play it for a CloB field.

is giving the registry error, saying q is muito "big" for the field!

Question: Does the Clob field take more than 4000 characters?

I am using 10g

valeu
Loader
gilbertoca
Rank: DBA Sênior
Rank: DBA Sênior
Posts: 372
Joined: Tue, 24 Jan 2006 3:33 pm
Location: Palmas - TO
Contact:

Take a look at this link http://download.oracle.com/docs/cd/B193 ... m#i1006803

If your English is capegregating, at least look at the examples and you will understand.

Gilberto
User avatar
fbifabio
Moderador
Moderador
Posts: 199
Joined: Tue, 22 Feb 2011 1:51 pm
Location: São Paulo - SP
Contact:

Personally, below the link of an article that I published in my blog about SQL Loader, which maybe help to take some doubts:

http://www.fabioprado.net/2010/10/carga ... o-sql.html
]

Fábio Prado
Post Reply
  • Information
  • Who is online

    Users browsing this forum: No registered users and 3 guests