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: 25578
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 failed due to ORACLE error 20000 encountered
Next Topic: Explain Plan
Goto Forum:

Current Time: Tue Aug 22 19:45:55 CDT 2017

Total time taken to generate the page: 0.05508 seconds