Kind of to confirm what Dick said: linrac2-> expdp klidh@linasm2 schemas=klidh directory=backup_dir dumpfile=klidh logfile=klidh.log Export: Release 10.2.0.1.0 - Production on Friday, 26 January, 2007 10:54:53 Copyright (c) 2003, 2005, Oracle. All rights reserved. Password: Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production With the Partitioning, Real Application Clusters, OLAP and Data Mining options Starting "KLIDH"."SYS_EXPORT_SCHEMA_01": klidh/********@linasm2 schemas=klidh directory=backup_dir dumpfile=klidh.dmp logfile=klidh.log Estimate in progress using BLOCKS method... Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA Total estimation using BLOCKS method: 0 KB Processing object type SCHEMA_EXPORT/USER Processing object type SCHEMA_EXPORT/SYSTEM_GRANT Processing object type SCHEMA_EXPORT/ROLE_GRANT Processing object type SCHEMA_EXPORT/DEFAULT_ROLE Processing object type SCHEMA_EXPORT/TABLESPACE_QUOTA Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA Processing object type SCHEMA_EXPORT/TABLE/TABLE Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS Processing object type SCHEMA_EXPORT/TABLE/COMMENT Master table "KLIDH"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded ****************************************************************************** Dump file set for KLIDH.SYS_EXPORT_SCHEMA_01 is: /u01/oracle/klidh.dmp Job "KLIDH"."SYS_EXPORT_SCHEMA_01" successfully completed at 10:57:10 linrac2-> sqlplus '/ as sysdba' SQL*Plus: Release 10.2.0.1.0 - Production on Fri Jan 26 10:57:59 2007 Copyright (c) 1982, 2005, Oracle. All rights reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production With the Partitioning, Real Application Clusters, OLAP and Data Mining options sys@LINASM> show parameter streams NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ streams_pool_size big integer 0 sys@LINASM> show parameter sga NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ lock_sga boolean FALSE pre_page_sga boolean FALSE sga_max_size big integer 200M sga_target big integer 200M sys@LINASM> linrac2-> The only difference being that I ran my expdp locally and not remotely from a Windows box. HTH, Kevin On Fri, 2007-01-26 at 12:35 -0500, Richard J. Goulet wrote: > 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 > > -- //www.freelists.org/webpage/oracle-l