RE: expdp not working

  • From: Kevin Lidh <kevin.lidh@xxxxxxxxx>
  • To: rgoulet@xxxxxxxxxx
  • Date: Fri, 26 Jan 2007 11:13:57 -0700

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


Other related posts: