Please someone help me on this one.

I have a table like this:

SQL> desc cs_accounting_log;
Name Null? Type
------------------------------ ---- -------- --------------------
LOG_ID NOT NULL NUMBER(38)
BLOB_ORDINAL NOT NULL NUMBER(38)
BLOB_DATA NOT NULL VARCHAR(255)

And in column BLOB_DATA, one record is made of mutiple values. Ex.

SQL> select * from cs_accounting_log where BLOB_DATA like '%apurcell%';

LOG_ID BLOB_ORDINAL
---------- ------------
BLOB_DATA
--------------------------------------------------------------------------------
80014 1
ubr117.cmts.hcvlny.cv.net apurcell tty2 167.206.112.181 start server=auth0 time=05:45:46 date=10/21/2001 task_id=2031 start_time=1003657546 timezone=edt service=shell

80015 1
ubr117.cmts.hcvlny.cv.net apurcell tty2 167.206.112.181 stop server=auth0 time=05:45:48 date=10/21/2001 task_id=2031 start_time=1003657546 timezone=edt service=shell
disc-cause=1 disc-cause-ext=1020 elapsed_time=2 nas-rx-speed=0 nas-tx-spee
d=0

80016 1
ubr117.cmts.hcvlny.cv.net apurcell tty2 167.206.112.181 start server=auth0 time=05:46:18 date=10/21/2001 task_id=2032 start_time=1003657577 timezone=edt service=shell


How do I break down those fields in BLOB_DATA column so that I can do some query? I am thinking of creating another table with multiple columns, but how do I load the data in that table?

Any help will be greatly appreciated.