Home » RDBMS Server » Server Utilities » Issue with data pump export (oracle 10g)
Issue with data pump export [message #525317] Sat, 01 October 2011 01:07 Go to next message
kailas
Messages: 21
Registered: September 2011
Location: pune
Junior Member
Hi,
i am exporting the schema of user kailas by using the data pump export but i am facing the some issue.Following are the details

[oracle@localhost dbs]$ expdp kailas/kailas DIRECTORY=dump_dir dumpfile=testexp01.dmp logfile=dump_dir:mylog.log

Export: Release 10.2.0.1.0 - Production on Saturday, 01 October, 2011 16:50:07

Copyright © 2003, 2005, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
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 KAILAS
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_20111001165007" and "KUPC$S_1_20111001165007" 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


[oracle@localhost dbs]$

i am not able to understand what exactly is the issue.
Re: Issue with data pump export [message #525319 is a reply to message #525317] Sat, 01 October 2011 01:12 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
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.

Regards
Michel
Re: Issue with data pump export [message #525325 is a reply to message #525319] Sat, 01 October 2011 02:16 Go to previous messageGo to next message
kailas
Messages: 21
Registered: September 2011
Location: pune
Junior Member
Hi,
i am trying to configure the streams_pool_size but it gives me following error and i have a spfile rather than pfile.

alter system set streams_pool_size=10m scope=both
*
ERROR at line 1:
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-04033: Insufficient memory to grow pool
Re: Issue with data pump export [message #525333 is a reply to message #525325] Sat, 01 October 2011 02:56 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ ALTER SYSTEM ... SCOPE=SPFILE;
2/ SHUTDOWN IMMEDIATE
3/ STARTUP

Regards
Michel
Previous Topic: How to update existing table using SQL Loader
Next Topic: Sql Loder Issues
Goto Forum:
  


Current Time: Thu Mar 28 15:53:19 CDT 2024