Friday, 22 June 2012

ORA-00832: no streams pool created and cannot automatically create one


ORA-00832: no streams pool created and cannot automatically create one
Cause: A database feature which needs STREAMS SGA was being used, however,  the
streams_pool_size parameter was not defined and the value of db_cache_size  was too small to permit an automatic transfer of SGA to the streams pool from the  buffer cache.
Action: Please set the parameter streams_pool_size or set sga_target.

No comments:

Post a Comment