多语言展示
当前在线:674今日阅读:113今日分享:31

数据库迁移步骤

迁移调整数据库表结构
方法/步骤
1

打开PL/SQL命令窗口

2

复制粘贴命令drop table '__MigrationHistory';Enter键执行

3

复制粘贴命令并执行alter table 'KBE'.'H3C_PACK_PCODE_PREFIX' add ('Remarks' nclob null);alter table 'KBE'.'H3C_PACK_MATERIAL_PRICE' add ('Unit' nclob null);alter table 'KBE'.'H3C_PACK_PROCESS_PRICE' add ('Remarks' nclob null);alter table 'KBE'.'H3C_PACK_PRINT_NUMBER' add ('Remarks' nclob null);alter table 'KBE'.'H3C_PACK_NAIL_NUMBER' add ('Remarks' nclob null);alter table 'KBE'.'H3C_PACK_ACCESSORIES_PRICE' add ('Remarks' nclob null);alter table 'KBE'.'H3C_PACK_ACCESSORIES_PRICE' add ('Unit' nclob null);alter table 'KBE'.'H3C_PACK_PACKAGE_PRICE' add ('Remarks' nclob null);alter table 'KBE'.'H3C_PACK_TRANSPORTATION_PRICE' add ('Remarks' nclob null);alter table 'KBE'.'H3C_PACK_PROFIT_FACTOR' add ('Remarks' nclob null);alter table 'KBE'.'H3C_PACK_TECH_REQUIREMENT' add ('Remarks' nclob null);

4

完成

推荐信息