今天对一张表进行迁移的时候发现报以下错误,参考飞总处理过程,原文链接:%E4%BD%BF%E7%94%A8copy%E5%AE%9E%E7%8E%B0long%E7%B1%BB%E5%9E%8B%E8%BD%AC%E7%A7%BB%E8%A1%A8%E7%A9%BA%E9%97%B4.html
SQL> alter table PMLBIN move tablespace ZNJK;
alter table PMLBIN move tablespace ZNJK
*
ERROR at line 1:
ORA-00997: illegal use of LONG datatype
生成ddl语句
SQL> select dbms_metadata.get_ddl('TABLE','PMLBIN','ZNJK') from dual;
CREATE TABLE "ZNJK"."PMLBIN"
( "LBIN" NUMBER(*,0) NOT NULL ENABLE,
"NUMR" NUMBER(*,0) NOT NULL ENABLE,
"BDAT" LONG RAW
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS
1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAU