CCU迁移

• 对sql server里的数据做BCP导出工作:在命令行下进行操作：
  • 关于ACCU的导出

bcp  queryout c\test1bat c T
导出了条数据。
关于PCCU的导出
bcp  queryout c\test2bat c T

导出了64181条数据。

• 建立分区表
  • ACCU脚本：

  ACCU_Daily_His

site_cd 
create_ts 
site_id 
GROUP_ID 
accu_val 
accu_val_avg 

  create_ts
 
	 ACCU_Daily_His_before_2004  less than TO_DATE
	 ACCU_Daily_His_2004  less than TO_DATE
	 ACCU_Daily_His_2005  less than TO_DATE
	 ACCU_Daily_His_2006  less than TO_DATE
	 ACCU_Daily_His_2007  less than TO_DATE
	 ACCU_Daily_His_2008  less than TO_DATE
	 ACCU_Daily_His_2009  less than TO_DATE
	 ACCU_Daily_His_2010  less than TO_DATE
	 ACCU_Daily_His_2011  less than TO_DATE
	 ACCU_Daily_His_2012  less than TO_DATE
	 ACCU_Daily_His_2013  less than TO_DATE
	 ACCU_Daily_His_2014  less than TO_DATE

• • PCCU脚本：

  PCCU_Daily_His

site_cd 
create_ts 
site_id 
GROUP_ID 
pccu_val 
pccu_val_avg 

  create_ts

 
         p_PCCU_His_Before_2004  less than TO_DATE
	 p_PCCU_His_2004  less than TO_DATE
	 p_PCCU_His_2005  less than TO_DATE
	 p_PCCU_His_2006  less than TO_DATE
	 p_PCCU_His_2007  less than TO_DATE
	 p_PCCU_His_2008  less than TO_DATE
	 p_PCCU_His_2009  less than TO_DATE
	 p_PCCU_His_2010  less than TO_DATE
	 p_PCCU_His_2011  less than TO_DATE
	 p_PCCU_His_2012  less than TO_DATE
	 p_PCCU_His_2013  less than TO_DATE
	 p_PCCU_His_2014  less than TO_DATE

• 取出test1.bat,test2.bat文件放在10.127.16.15上，并在同一路径建立控制文件input1.ctl,input2.ctl。
  • input1.ctl脚本：

load data
infile 
append   KPIACCU_Daily_His
fields terminated  X
site_cdcreate_ts site_idGROUP_IDaccu_valaccu_val_avg

• • input2.ctl脚本：

load data
infile 
append   KPIPCCU_Daily_His
fields terminated  X
site_cdcreate_ts site_idGROUP_IDpccu_valpccu_val_avg

• 导入数据：

在命令行下同一路径下：

sqlldr KPIkpigamenoworads controlinput1ctl
sqlldr KPIkpigamenoworads controlinput2ctl

这样就OK了。 PS: 建表的时候 site_id为char(4)需要在导入数据前修改类型为 varchar(6)。

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/25618347/viewspace-713876/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/25618347/viewspace-713876/