哦,这个简单,你可以执行以下步骤:
startup nomount;
alter database mount exclusive;
alter system enable restricted session;
alter system set job_queue_processes=0;
alter database open;
alter database character set zhs16gbk;
During the Export or Import a buffer overflowed.This error most likelyoccured when using Export/Import remotely and connecting to the source/targetdatabase via SQLNet v2 or Net 8, but this error can happend when Export/Importused locally (i.e., not using SQLNet v2 or Net 8 to connect).
The amount of data buffered by Export/Import needs to be reduced to prevent theoverflow from happening.
For example:If BUFFER is set to 10485760 (10 MB), this will cause Export to buffer 10MB ofdata before writing it to the export dump file.This would cause Import tobuffer 10MB of data before actually sending it to the database (write todatafiles).This becomes a problem when doing Export/Import remotely.10MB ofdata will try to be sent across the network at one time.On the average anetwork packet (buffer) size is 1500 bytes.So trying to send 10MB at one timevia 1500 byte packets is causing the overflow to occur.