As a debugging technique, you could also perform the import with SHOW=Y to see the SQL syntax of what the imp is really doing.<br>
<br>
My guess is that the imp you did didn't import any rows, or you would have gotten the message:<br>
. . importing table "MVC_FILE" n rows...
We figured out the problem, and Oracle Support is working on a bug fix.<br>
<br>
The problem was that We were importing the schema, then the data, then the indices as 3 different imports. The failure occured on the data step.<br>
<br>
It turns out that there was a view (a non-SYSTEM view) that...
I have been having doing a full import into an Oracle 8.0.5.1 instance The following is the error I've been getting: <br>
<br>
ORA-04030: out of process memory when trying to allocate 24 bytes (callheap,temporary memory)<br>
<br>
I've tried playing around with the buffer size to no avail.<br>...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.