RE: expdp not working
- From: "Richard J. Goulet" <rgoulet@xxxxxxxxxx>
- To: <Harvinder.Singh@xxxxxxxxxxxxx>, "oracle-l" <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 26 Jan 2007 12:35:22 -0500
I think the error at the very bottom of the stack says it all:
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.
Dick Goulet, Senior Oracle DBA
45 Bartlett St Marlborough, Ma 01752, USA
Tel.: 598.573.1978 |Fax: 508.229.2019 | Cell:508.742.5795
RGoulet@xxxxxxxxxx
: POWERING TRANSFORMATION
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]
Sent: Friday, January 26, 2007 11:31 AM
To: oracle-l
Subject: expdp not working
Hi,
We are getting the following error while running expdp and I didn't
found munch information on this error on google, Did anyone saw this
error on their environment and what was the problem/solution?
S:\>expdp nm/nm@linux schemas=nm directory=backup_dir dumpfile=nm.dmp
logfile=nm.log
Export: Release 10.2.0.2.0 - Production on Friday, 26 January, 2007
11:19:30
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0
- Produc
tion
With the Partitioning, OLAP and Data Mining options
ORA-31626: job does not exist
ORA-31637: cannot create job SYS_EXPORT_SCHEMA_01 for user SYSTEM
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPV$FT_INT", line 600
ORA-39080: failed to create queues "KUPC$C_1_20070126111433" and
"KUPC$S_1_20070 126111433" for Data Pump job
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPC$QUE_INT", line 1555
ORA-00832: no streams pool created and cannot automatically create one
Environemnt: 10.2.0.1 on RHAT4
Thanks
--Harvinder
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
