Oracle PLSQL export data table xx contains one or more CLOB columns Solution

Oracle PLSQL export data table xx contains one or more CLOB columns Solution

When Oracle exports data, the Table xx contains one or more CLOB columns error occurs. This indicates that the Table contains multiple clob types and cannot be exported.

There are three PLSQL export methods. The first method is to export a. dmp file. It is a binary file and has good versatility and can be used across platforms. The second method is to export the. SQL file. The advantage is that you can see the SQL statement, which is suitable for small data volumes and cannot contain large fields (blob, clob, and long ). The third method is to export the. PVDF file, which is a special plsql format. Only plsql knows it, and other compilers do not know it.

If you encounter this problem, you can use the first method to export the content.

 

Foreign key conflicts may occur during import. In this case, we need to block the foreign key constraints, import them, and then enable the foreign key constraints.

SQL that shields Foreign keys:

Select 'alter table' | table_name | 'Disable constraint' | constraint_name | ';' from user_constraints where constraint_type = 'R'

SQL statement for restoring foreign key constraints:

Select 'alter table' | table_name | 'Enable constraint' | constraint_name | ';' from user_constraints where constraint_type = 'R'

The above script only Concatenates the foreign key operation of the corresponding table and runs the query results.