Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

The oracle 10g DB that is being currently used has exceeded the limit of 4GB. For the application to continue the db needs to be upgraded to 11g. But the upgrade doc requires a data pump export to be done from 10g and then data pump import it to 11g.

But the concern is the 10g exceeding its limit of 4GB and hence will not allow a data pump export to be done. Is there any alternate option to move the data to 11g other than data pump export and import.

Have tried the export with expdp but i get an error saying the database has exceeded th 4gb limit.

share|improve this question
    
Have you tried the export? If so, what error message(s) did you get? -- Also this question might to better on dba.stackexchange.com - add the information above and we can move it for you. –  voretaq7 May 17 '12 at 15:10
    
Have edited my post. I ried the 'expdp' option. But i get the atabase has exceeded 4GB limit and does not proceed. –  zapping May 17 '12 at 19:06
    
The issue was resolved. Since this question is not closed. If anybody stumbles into here with a similar issue. The resolution is here dba.stackexchange.com/questions/18131/… –  zapping Jun 8 '12 at 13:11

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.