Tag Archives: ORA-00832

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

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

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/