Shulou(Shulou.com)06/01 Report--

Description: customers need to do data migration, migrate from Oralce 10g to 11g RAC environment, use exp direct path export, import to 11g error ORA-1400. It is suggested that after 10g, you can use the data pump to migrate the database, which can be concurrent. 10g does not support data compression, but 11g supports compression. 1. Error message You exported a table using the original export utility (exp) in direct path mode. During import, you received the errors:. . Importing table "A_TAB" IMP-00019: row rejected due to ORACLE error 1400 IMP-00003: ORACLE error 1400 encountered ORA-01400: cannot insert NULL into ("TEST". "A_TAB". "COL001") Column: 1 Column: 2, solution SOLUTION1. Use DataPump export/import utilities (expdp/impdp)-OR-2. Start traditional export utility (exp) in conventional path mode (DIRECT=N).

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.