IMP-00020 error solution

xiaoxiao2021-03-06  74

Today, the on-site personnel came over and said that the error was introduced, and it could not be imported normally.

Since the data that needs to be imported is large, it is exported in a table as a table.

The export file of a single table has 2.9G, when imported:

IMP-00020: Long Column Too Large for Column Buffer Size (22)

IMP-00028: Partial Import of Previous Table Rolled Back: 489860 ROWS ROLLED BACK

8174's database, first check Metalink, found a bunch of instructions

It looks different from your situation.

Finally, I saw a Maybe Dump File Corrupt.

Dizzy, quickly let the scene check the DMP file and find that the DMP file actually uploaded to the server is nearly 10m larger than the original document.

Is it a big 10m? It's rare, this TCP / IP is not very good.

So let the on-site personnel use the original DMP file directly to import

Ok, a smooth sailing.

转载请注明原文地址:https://www.9cbs.com/read-108848.html

New Post(0)