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.
Best Answer
I would try the following:
Install an oracle 10g database software that I download from the oracle software download page (i have the appropriate license)
create an empty database with this software
using the exp-tool (classical export, not datapump) to make an export from the database
import the dumpfile (with the classical imp tool) in the empty 10g database I created
now i do the export from this database and import this in the 11g database
step 3. is possible because the classical export does not create any table in the database in contrast to the datapump export. so i think i will not hit the 4g LIMIT ERROR
step 5 is possible because now the expdp is not constrained by any 4G limit.
it is not supported to import in step 4 into an 11g database but one can try if this is possible.