使用
to_timestamp_tz 进行apache日志格式时间导入。
SQL> insert into apache (REMOTE_HOSTNAME, REMOTE_LOGNAME, REMOTE_USER, REQUEST_TIME , REQUEST, STATUS, RESPONSE_BYTES, REFERER, USER_AGENT, RECEIVED_BYTES, TRANSFERRED_BYTES, PID, TAKEN_TIME, RESPONSE_BYTES_B) values ('183.63.119.36', '-', '-', to_timestamp_tz('24/Nov/2013:10:06:39 +0800','dd/mon/yy:hh24:mi:ss +TZHTZM'), 'GET /pic/cabb0c3f9b39a32d762fc5a0244004bf.jpg HTTP/1.1', '200', '23391', 'http://hdcmct.org/forums.php?action=viewtopic'||'&'||'forumid=9'||'&'||'topicid=4975', 'Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 5.1; Trident/4.0; LBBROWSER)', '335', '23665', '2477', '500601', '23391');
1 row created.
SQL>
SQL> insert into apache (REMOTE_HOSTNAME, REMOTE_LOGNAME, REMOTE_USER, REQUEST_TIME , REQUEST, STATUS, RESPONSE_BYTES, REFERER, USER_AGENT, RECEIVED_BYTES, TRANSFERRED_BYTES, PID, TAKEN_TIME, RESPONSE_BYTES_B) values ('183.63.119.36', '-', '-', to_timestamp_tz('24/Nov/2013:10:06:39 +0800','dd/mon/yy:hh24:mi:ss +TZHTZM'), 'GET /pic/cabb0c3f9b39a32d762fc5a0244004bf.jpg HTTP/1.1', '200', '23391', 'http://hdcmct.org/forums.php?action=viewtopic'||'&'||'forumid=9'||'&'||'topicid=4975', 'Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 5.1; Trident/4.0; LBBROWSER)', '335', '23665', '2477', '500601', '23391');
1 row created.
SQL>
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/11780477/viewspace-777431/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/11780477/viewspace-777431/