From Oracle Database Forum (same error):
Are you trying to do import with COMMIT=N option?
What is your buffer size in import command?
What is the size of your export dump?
If you have big tables, you may want to try with commit=Y, buffer=30m or 50m (try with 50m first)
Create a big rollback segment and make all other rollback segment offline except system.
I've tried reducing the size of the buffer, but problem remains..
Any other clue?
Is the Import process's memory is growing when it's running?
If the error is happening on a large table, you might consider partitioning the table then export/import the parts
From the information I can gather, this is a bug fixed in 8.1.7 (although the error notes are from 8.1.6 not 8.0.5)
Best of luck to you.
Thank you very much.
I'll try to see what I can do about it.
Nevertheless, table size would not be a problem as import of larger tables had succeeded.
AFIK that table seems to be related with some sort of database sync. with remote nodes, which is said to be offline. So I'm thinking about excluding that particular schema.
By the way... How do I reset Advanced Queuing?, i.e. remove all AQ's records and start from scratch.
I'm glad you think you have the solution.
I recommend purchasing a support contract and access to Metalink.
Isn't AQ called Streams now?
Click Here to Expand Forum to Full Width