Home » RDBMS Server » Server Utilities » sql loader question (Oracle 8i, Solaris 8)
sql loader question [message #333911] Mon, 14 July 2008 19:07 Go to next message
Messages: 37
Registered: May 2003
hi everybody,
I am trying to replace some scripts that populate some Oracle 8i tables with some sqlloader jobs. The trick is that the files I am trying to work with are structured as follows:

date: YYYY-MM-DD
header: item1=value, item2=value
header cont: item3=value, item4=value
item5, item6, item7, item8
value, value, value, value
value, value, value, value

whereas the tables contain the item1 thru to item4 and the date as columns (plus the rest item5 thru item8). I know the design is not great (cols 1 to 4 are redundant, plus the date) but this is what I got now.

I can't think of an elegant way to get everything in one pass.
I don't know if I have any parsing ability with sqlldr, I also am restricted to sqlldr since I don't have access to the file system, hence no plsql solution ...

Thanks in advance for any suggestion you may have,
Re: sql loader question [message #333916 is a reply to message #333911] Mon, 14 July 2008 20:09 Go to previous message
Messages: 24958
Registered: January 2009
Location: SoCal
Senior Member
Please read & follow Posting Guideline as stated above

Since you are stuck with 8i, you can not accomplish your goal with sqlldr.
Keep the scripts.

V8i obsolete & has not been supported this century.
Previous Topic: export error : converting column overflows integer datatype
Next Topic: Imp error: partial import of previous table rolled back
Goto Forum:

Current Time: Sat Oct 22 02:23:08 CDT 2016

Total time taken to generate the page: 0.10697 seconds