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
kowalsky
Messages: 37
Registered: May 2003
Member
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
data:
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,
kowalsky
Re: sql loader question [message #333916 is a reply to message #333911] Mon, 14 July 2008 20:09 Go to previous message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
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: Fri Dec 09 21:21:38 CST 2016

Total time taken to generate the page: 0.25878 seconds