个人简介
偶尔有空上来看看
文章分类
文章存档
最近访客
相关博文
- ·
- ·
- ·
- ·
- ·
- ·
- ·
- ·
- ·
- ·
分类： oracle
2023-07-20 15:22:24
数据导入时大量宽度不足
可以简单加工一下
还不完美，没有能够实现只显示max宽度
-
-
ora-02374: conversion error loading table "scott"."person"
-
ora-12899: value too large for column occupation (actual: 60, maximum: 50)
-
ora-02374: conversion error loading table "scott"."person"
-
ora-12899: value too large for column employee (actual: 75, maximum: 50)
-
ora-02374: conversion error loading table "scott"."person"
-
ora-12899: value too large for column employee (actual: 60, maximum: 50)
-
ora-02374: conversion error loading table "scott"."person"
-
ora-12899: value too large for column employee (actual: 57, maximum: 50)
-
ora-02374: conversion error loading table "scott"."person"
-
ora-12899: value too large for column employee (actual: 60, maximum: 50)
-
ora-02374: conversion error loading table "scott"."person"
-
ora-12899: value too large for column employee (actual: 53, maximum: 50)
-
ora-02374: conversion error loading table "scott"."person"
-
ora-12899: value too large for column duty (actual: 74, maximum: 50)
-
ora-02374: conversion error loading table "scott"."person"
-
ora-12899: value too large for column employee (actual: 60, maximum: 50)
-
ora-02374: conversion error loading table "scott"."address"
-
ora-12899: value too large for column name (actual: 70, maximum: 50)
-
ora-02374: conversion error loading table "scott"."address"
-
ora-12899: value too large for column name (actual: 81, maximum: 50)
-
ora-02374: conversion error loading table "scott"."address"
-
ora-12899: value too large for column phonenumber (actual: 18, maximum: 15)
-
ora-02374: conversion error loading table "scott"."user"
- ora-12899: value too large for column remark (actual: 180, maximum: 100)
-
#!/bin/sh
-
-
i=1
-
width=0
-
fn=/tmp/out.log
-
echo > $fn
-
cat t.txt | while read line
-
do
-
i=$(($i1))
-
errcode='ora-02374'
-
if [[ $line =~ $errcode ]]
-
then
-
table=`echo $line |awk -f"conversion error loading table" '{print $2}'`
-
fi
-
-
largecode='ora-12899'
-
if [[ $line =~ $largecode ]]
-
then
-
column=`echo $line |awk -f"value too large for column" '{print $2}'|awk -f"(" '{print $1}'`
-
width=`echo $line |awk -f"actual:" '{print $2}'|awk -f"," '{print $1}'`
-
fi
-
-
# alter table
-
if [[ $line =~ $largecode ]] && [[ $width -gt 0 ]]
-
then
-
echo 'alter table ' $table ' modify ' $column ' varchar2(' $width ');' >> $fn
-
width=0
-
fi
-
-
done
-
-
sort $fn|uniq
-
-
# 求max值
- # awk -f"[()]" '{print $2}'|awk 'begin{ max = 0} {if ($1 > max) max = $1; fi} end{print max}'
给主人留下些什么吧！~~