-
编辑 删除
Methods for processing duplicate records
The measurement of duplicate is the values of two or more records for columns(prod_id,cust_id,time_id) are the same. select prod_id,cust_id,time_id,channel_id,promo_id,quantity_sold,amount_sold from (...
-
编辑 删除
sql loader Case Study 2: Loading Fixed-Format Fields
Case 2 demonstrates:A separate datafile. See Specifying Datafiles.Data conversions. See Datatype Conversions.In this case, the field positions and datatypes are specified explicitly. Control Fil...
-
编辑 删除
sql loader Case Study 1: Loading Variable-Length Data
Case 1 demonstrates:A simple control file identifying one table and three columns to be loaded.Including data to be loaded from the control file itself, so there is no separate datafile. See Identi...
-
编辑 删除
split the segment by rowid for parallel process
select grp, dbms_rowid.rowid_create( 1, data_object_id, lo_fno, lo_block, 0 ) min_rid, dbms_rowid.rowid_create( 1, data_object_id, hi_fno, hi_block, 10000 ) max_rid from (select disti...
-
编辑 删除
oracle 11g impdp 中断之后，继续执行的方法
$ impdp system/cloudwave1 schemas=icopy directory=dir_dump file=icopy20120619.dmp执行到一半，由于机器要做性能测试，所以暂停任务。按CTRL+C之后输入Import> stop_job退回到控制台。当需要继续运行impdp时...
-
编辑 删除
Statement和PreparedStatement中char 类型字段的判断不同。
create table testchar(c1 char(10));insert into testchar(c1) values('a');--没有空格select * from testchar where c1='a'--有一个空格select * from testchar where c1='a ';--多于10个空格select * from testch...
