Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: expdp not working

RE: expdp not working

From: Kevin Lidh <kevin.lidh_at_gmail.com>
Date: Fri, 26 Jan 2007 11:13:57 -0700
Message-Id: <1169835238.4537.2.camel@lidhfed.lidh.com>


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/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_at_LINASM> show parameter streams

NAME                                 TYPE        VALUE
------------------------------------ -----------
------------------------------
streams_pool_size                    big integer 0
sys_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 200M
sys_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-l
Received on Fri Jan 26 2007 - 12:13:57 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US