This content has been marked as final. Show 3 replies
Possible solutions depend on four digit Oracle version and edition and platform, neither of which you mention.
Streams is implemented by shipping and reading archivelogs, so if you disable archivelog streams will stop to function.
Something is architecturally really really wrong if you want top update 40 percent of the database in one shot.
You are trying to fight symptoms, where a cure is needed.
Problem is not archivelog. Problem is the architecture of this 'application'.
Senior Oracle DBA
The db version is RAC 10g 10.2.0.4
The cure is that I moved the data to another place, and now I have to delete the old data. The database without blobs has about 800 Gb. The design was not very good in tje first place, I know. Now I'm moving some of the blobs to another storage area.
Edited by: Adrian P on Jun 18, 2012 1:24 AM