import data file into Oracle database, using SQL*Loader utility … sqlldr … sql loader

use exp

For example, in the following example, benefits table has a column called v_status. This exp command will export only the rows that contains “INVALID” as value in the v_status column.

$ exp hradmin/mypassword TABLES=benefits query=\"where v_status=\'INVALID\'\"
..
About to export specified tables via Conventional Path ...
. . exporting table BENEFITS 20783 rows exported


 

SQL*Loader (sqlldr) is the utility to use for high performance data loads. The data can be loaded from any text file and inserted into the database.

螢幕快照 2014 09 03 上午10 42 12

Read more

2014.0817 石門草里漁港~金山中角沙珠灣 海泳

螢幕快照 2014 08 16 下午2 28 07

817 total map

起點: 草里港公車亭 , 新北市石門區阿里荖18之3 , http://goo.gl/maps/YvImg

4k : 中角派出所  map : http://goo.gl/maps/or9zn

5k : 新北市石門區  跳石 : http://goo.gl/maps/mqpTg 

上岸點 6.2k : 中角沙灘 : http://goo.gl/maps/zrTaU

04:00~05:30 準備船隻出海往草里
05:30 泳手 戒護手 就位
05:30~09:30 泳手勇往直前
09:30 中角沙珠灣考核結束
09:30 回萬里海水浴場拖船

2014.0817 石門草里漁港~金山中角沙珠灣 海泳 [MEMO]

Read more