Home » RDBMS Server » Server Utilities » Inserting targz files into table from specified folder (11g)
Inserting targz files into table from specified folder [message #566856] Thu, 20 September 2012 06:40 Go to next message
Maslakos
Messages: 3
Registered: September 2012
Location: Poland
Junior Member
Hello, i`m new with Oracle DB. I used search option but i didn`t find answer to my question. My problem is with importing files into table( 2 columns > 1 number, 2 clob ). I can`t use SQL Loader becouse i need to load 30.000 tar.gz files from 1 folder, IMPORT option in SQL developer didn`t work too. Can someone help me?

Report message to a moderator

Re: Inserting targz files into table from specified folder [message #566863 is a reply to message #566856] Thu, 20 September 2012 08:24 Go to previous message
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
Senior Member
I have no idea what your error is as you didn't show it, but tar.gz files are binary, therefore CLOB is incorrect. You need BLOB.

Report message to a moderator

Previous Topic: expdp where clause with subquery
Next Topic: Sql Loader
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Feb 11 18:19:42 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.