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?
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.
Previous Topic: expdp where clause with subquery
Next Topic: Sql Loader
Goto Forum:
  


Current Time: Thu Mar 28 04:55:47 CDT 2024