Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: expdp not working
Kind of to confirm what Dick said:
linrac2-> expdp klidh_at_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/CONSTRAINTProcessing object type
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_at_LINASM> show parameter streams
NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ streams_pool_size big integer 0sys_at_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 200Msys_at_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_at_kanbay.com
>
> : POWERING TRANSFORMATION
>
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org]
> 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_at_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
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Jan 26 2007 - 12:13:57 CST
![]() |
![]() |