如果将一个含有long类型的表的数据负责到相同结构的表中?

如何解决?SQL> desc ALL_CONSTRAINTS
Name              Type         Nullable Default Comments                                                                    
----------------- ------------ -------- ------- --------------------------------------------------------------------------- 
OWNER             VARCHAR2(30)                  Owner of the table                                                          
CONSTRAINT_NAME   VARCHAR2(30)                  Name associated with constraint definition                                  
CONSTRAINT_TYPE   VARCHAR2(1)  Y                Type of constraint definition                                               
TABLE_NAME        VARCHAR2(30)                  Name associated with table with constraint definition                       
SEARCH_CONDITION  LONG         Y                Text of search condition for table check                                    
R_OWNER           VARCHAR2(30) Y                Owner of table used in referential constraint                               
R_CONSTRAINT_NAME VARCHAR2(30) Y                Name of unique constraint definition for referenced table                   
DELETE_RULE       VARCHAR2(9)  Y                The delete rule for a referential constraint                                
STATUS            VARCHAR2(8)  Y                Enforcement status of constraint - ENABLED or DISABLED                      
DEFERRABLE        VARCHAR2(14) Y                Is the constraint deferrable - DEFERRABLE or NOT DEFERRABLE                 
DEFERRED          VARCHAR2(9)  Y                Is the constraint deferred by default -  DEFERRED or IMMEDIATE              
VALIDATED         VARCHAR2(13) Y                Was this constraint system validated? -  VALIDATED or NOT VALIDATED         
GENERATED         VARCHAR2(14) Y                Was the constraint name system generated? -  GENERATED NAME or USER NAME    
BAD               VARCHAR2(3)  Y                Creating this constraint should give ORA-02436.  Rewrite it before 2000 AD. 
RELY              VARCHAR2(4)  Y                If set, this flag will be used in optimizer                                 
LAST_CHANGE       DATE         Y                The date when this column was last enabled or disabled                      SQL> desc ief_ALL_CONSTRAINTS
Name              Type         Nullable Default Comments 
----------------- ------------ -------- ------- -------- 
OWNER             VARCHAR2(30)                           
CONSTRAINT_NAME   VARCHAR2(30)                           
CONSTRAINT_TYPE   VARCHAR2(1)  Y                         
TABLE_NAME        VARCHAR2(30)                           
SEARCH_CONDITION  LONG         Y                         
R_OWNER           VARCHAR2(30) Y                         
R_CONSTRAINT_NAME VARCHAR2(30) Y                         
DELETE_RULE       VARCHAR2(9)  Y                         
STATUS            VARCHAR2(8)  Y                         
DEFERRABLE        VARCHAR2(14) Y                         
DEFERRED          VARCHAR2(9)  Y                         
VALIDATED         VARCHAR2(13) Y                         
GENERATED         VARCHAR2(14) Y                         
BAD               VARCHAR2(3)  Y                         
RELY              VARCHAR2(4)  Y                         
LAST_CHANGE       DATE         Y                         SQL> insert into ief_ALL_CONSTRAINTS
  2  select * from  ALL_CONSTRAINTS
  3  WHERE OWNER = UPPER('ABCIEF') OR OWNER = UPPER('ABCIAS');insert into ief_ALL_CONSTRAINTS
select * from  ALL_CONSTRAINTS
WHERE OWNER = UPPER('ABCIEF') OR OWNER = UPPER('ABCIAS')ORA-00997: 非法使用Long数据类型
SQL>