小弟最近在帮公司解决一个问题,就是对于每个上网的用户每时每刻操作的记录进行分类插入不同的数据库表中;不知道从何下手了。小迷茫一番!请各位大虾帮忙解决一下。记录如下:
2010-04-16 09:20:48 Local7.Debug 10.255.255.2 ><PA>qvod.udp 1271412890-1271413169 10.255.255.7:1406-61.167.57.143:46526 182 0
2010-04-16 09:21:17 Local7.Debug 10.255.255.2 <PNB0>1271413197 10.255.255.122 GET http://img2.126.net/ntesrich/2010/0416/index/sanxing-11.js
2010-04-16 09:21:17 Local7.Debug 10.255.255.2 <PNB0>1271413197 10.255.255.122 GET http://img2.126.net/ntesrich/2010/0416/index/960-400-9.swf
2010-04-16 09:21:17 Local7.Debug 10.255.255.2 <PNB0>1271413197 10.255.255.122 GET http://img2.126.net/ntesrich/2010/0416/index/20-120-9.swf
2010-04-16 09:21:17 Local7.Debug 10.255.255.2 <PNB0>1271413197 10.255.255.122 GET http://img2.126.net/ntesrich/2010/0416/index/20-120-9.swf
2010-04-16 09:21:17 Local7.Debug 10.255.255.2 <PNB0>dnsquery 1271413197 163.wrating.com 10.255.255.122 202.102.224.68
2010-04-16 09:21:17 Local7.Debug 10.255.255.2 <PNB0>1271413197 10.255.255.122 GET http://163.wrating.com/a1.js
2010-04-16 09:21:18 Local7.Debug 10.255.255.2 <PNB0>dnsquery 1271413198 analytics.163.com 10.255.255.122 202.102.224.68
2010-04-16 09:21:18 Local7.Debug 10.255.255.2 <PNB0>1271413198 10.255.255.122 GET http://163.wrating.com/a.gif?a=128043474d9&t=&i=fae1b356.120292abbf6.0.649bdc4a9e2c8&b=http%3A//www.163.com/&c=860010-0503010000&s=1280x800x32&l=zh-cn&z=8&j=1&f=10.0&ut=11&n
2010-04-16 09:21:18 Local7.Debug 10.255.255.2 <PNB0>1271413198 10.255.255.122 GET http://analytics.163.com/ntes.js
2010-04-16 09:21:18 Local7.Debug 10.255.255.2 <PNB0>dnsquery 1271413198 adc.163.com 10.255.255.122 202.102.224.68
2010-04-16 09:21:18 Local7.Debug 10.255.255.2 <PNB0>1271413198 10.255.255.122 GET http://adc.163.com/ntesc?s=www
2010-04-16 09:21:18 Local7.Debug 10.255.255.2 <PNB0>dnsquery 1271413198 www.youdao.com 10.255.255.122 202.102.224.68
2010-04-16 09:21:18 Local7.Debug 10.255.255.2 <PNB0>1271413198 10.255.255.122 GET http://www.youdao.com/suggest/suggest.s?query=&o=aa&count=1&keyfrom=www.163.com.suggest&time=Fri%20Apr%2016%2009:21:06%20UTC+0800%202010
2010-04-16 09:21:18 Local7.Debug 10.255.255.2 <PNB0>dnsquery 1271413198 richmedia.minisite.163.com 10.255.255.122 202.102.224.68
2010-04-16 09:21:18 Local7.Debug 10.255.255.2 <PNB0>1271413198 10.255.255.122 GET http://richmedia.minisite.163.com/crossdomain.xml
2010-04-16 09:21:18 Local7.Debug 10.255.255.2 <PNB0>1271413199 10.255.255.122 POST http://richmedia.minisite.163.com/click.php?adid=588&lid=0&playtype=1
2010-04-16 09:21:20 Local7.Debug 10.255.255.2 <PNB0>1271413200 10.255.255.122 GET http://active.baofeng.com/active2?pid=2&id=364&uid={6DB6FBC7-DEEE-43C9-A56B-98F414A6E361}&t=7&v=3.09.11.23&idate=2008_12_25
2010-04-16 09:21:20 Local7.Debug 10.255.255.2 ><PA>http.tcp 1271413200-1271413200 10.255.255.122:1944-60.28.15.180:80 191 105
按照><PA>和<PNBO>建成两个表,从txt文档里将记录读取让后分类插入两个表中。
2010-04-16 09:20:48 Local7.Debug 10.255.255.2 ><PA>qvod.udp 1271412890-1271413169 10.255.255.7:1406-61.167.57.143:46526 182 0
2010-04-16 09:21:17 Local7.Debug 10.255.255.2 <PNB0>1271413197 10.255.255.122 GET http://img2.126.net/ntesrich/2010/0416/index/sanxing-11.js
2010-04-16 09:21:17 Local7.Debug 10.255.255.2 <PNB0>1271413197 10.255.255.122 GET http://img2.126.net/ntesrich/2010/0416/index/960-400-9.swf
2010-04-16 09:21:17 Local7.Debug 10.255.255.2 <PNB0>1271413197 10.255.255.122 GET http://img2.126.net/ntesrich/2010/0416/index/20-120-9.swf
2010-04-16 09:21:17 Local7.Debug 10.255.255.2 <PNB0>1271413197 10.255.255.122 GET http://img2.126.net/ntesrich/2010/0416/index/20-120-9.swf
2010-04-16 09:21:17 Local7.Debug 10.255.255.2 <PNB0>dnsquery 1271413197 163.wrating.com 10.255.255.122 202.102.224.68
2010-04-16 09:21:17 Local7.Debug 10.255.255.2 <PNB0>1271413197 10.255.255.122 GET http://163.wrating.com/a1.js
2010-04-16 09:21:18 Local7.Debug 10.255.255.2 <PNB0>dnsquery 1271413198 analytics.163.com 10.255.255.122 202.102.224.68
2010-04-16 09:21:18 Local7.Debug 10.255.255.2 <PNB0>1271413198 10.255.255.122 GET http://163.wrating.com/a.gif?a=128043474d9&t=&i=fae1b356.120292abbf6.0.649bdc4a9e2c8&b=http%3A//www.163.com/&c=860010-0503010000&s=1280x800x32&l=zh-cn&z=8&j=1&f=10.0&ut=11&n
2010-04-16 09:21:18 Local7.Debug 10.255.255.2 <PNB0>1271413198 10.255.255.122 GET http://analytics.163.com/ntes.js
2010-04-16 09:21:18 Local7.Debug 10.255.255.2 <PNB0>dnsquery 1271413198 adc.163.com 10.255.255.122 202.102.224.68
2010-04-16 09:21:18 Local7.Debug 10.255.255.2 <PNB0>1271413198 10.255.255.122 GET http://adc.163.com/ntesc?s=www
2010-04-16 09:21:18 Local7.Debug 10.255.255.2 <PNB0>dnsquery 1271413198 www.youdao.com 10.255.255.122 202.102.224.68
2010-04-16 09:21:18 Local7.Debug 10.255.255.2 <PNB0>1271413198 10.255.255.122 GET http://www.youdao.com/suggest/suggest.s?query=&o=aa&count=1&keyfrom=www.163.com.suggest&time=Fri%20Apr%2016%2009:21:06%20UTC+0800%202010
2010-04-16 09:21:18 Local7.Debug 10.255.255.2 <PNB0>dnsquery 1271413198 richmedia.minisite.163.com 10.255.255.122 202.102.224.68
2010-04-16 09:21:18 Local7.Debug 10.255.255.2 <PNB0>1271413198 10.255.255.122 GET http://richmedia.minisite.163.com/crossdomain.xml
2010-04-16 09:21:18 Local7.Debug 10.255.255.2 <PNB0>1271413199 10.255.255.122 POST http://richmedia.minisite.163.com/click.php?adid=588&lid=0&playtype=1
2010-04-16 09:21:20 Local7.Debug 10.255.255.2 <PNB0>1271413200 10.255.255.122 GET http://active.baofeng.com/active2?pid=2&id=364&uid={6DB6FBC7-DEEE-43C9-A56B-98F414A6E361}&t=7&v=3.09.11.23&idate=2008_12_25
2010-04-16 09:21:20 Local7.Debug 10.255.255.2 ><PA>http.tcp 1271413200-1271413200 10.255.255.122:1944-60.28.15.180:80 191 105
按照><PA>和<PNBO>建成两个表,从txt文档里将记录读取让后分类插入两个表中。
解决方案 »
- 定义函数返回值类型为对象,如何调用?
- Oracle9i用户下的表导入到Oracle10g里面-----急,在线等
- oracle , left join in连接一个子查询,结果为什么是空
- 重装系统后 如何启动oracle服务
- 发个“蛋”帖,嘿嘿~
- 如何将EXCEL中的数据批量导入到ORACLE数据库?
- 请问如何查看一个blob字段内容?
- 为什么不能group by
- 机子上原来装SQL Server2000,现在想装oracle 9i Release 请问应该注意些什么问题吗?
- 简单问题:orcale下用那个系统库来建用户库。比如在sqlserver中系统一般都使用master数据库来建立其他用户数据库的!
- oracle性能优化问题
- 如何用透明网关连接MYsql啊
如果要加载格式规范的文本文件,可用sql*loader或者外部表