1

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.

zapping
  • 183
  • 1
  • 9
  • Have you *tried* the export? If so, what error message(s) did you get? -- Also this question might to better on http://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 http://dba.stackexchange.com/questions/18131/oracle-10g-xe-to-11g-xe-upgrade – zapping Jun 08 '12 at 13:11

0 Answers0