QUESTION POSED ON: 13 February 2004
We are in the process of upgrading from Oracle 8.0.5 to Oracle 9i. Forgive me if I get things wrong, but my DBAs first language is not English so I'm asking this question on his behalf given the information I have.
The problem seems to be similar to one posed one your site previously (in May 2002) but there was no clear answer.
We have some PL/SQL procedures that are wrapped. When these are exported from an Oracle 8 database the dump file will import fine into the Oracle 9i database. When the Oracle 9i database is subsequently exported, there is a problem re-importing it. The import gets to the point where it is importing the stored procedures, then the memory usage goes through the roof and eventually the machine runs out of resource. My DBA tells me the effect happens because the procedures are wrapped. He has proved this by importing the same information when they are not wrapped which is successful.
We have not been able to get information to confirm whether this is a bug, or if there is something we can change in the configuration. Any help would be appreciated.
|
