导出时
expdp system/ets directory=dumpdir dumpfile=chimei_expdp schemas=chimei logfile=exp_kanekoh.log
oracle@mdsetsdb02:/oracle11g/oracle>./expdp_kanekoh.sh
Export: Release 11.1.0.6.0 - 64bit Production on Wednesday, 17 October, 2012 9:24:28
Copyright (c) 2003, 2007, Oracle.All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
UDE-31623: operation generated ORACLE error 31623
ORA-31623: a job is not attached to this session via the specified handle
ORA-06512: at "SYS.DBMS_DATAPUMP", line 2862
ORA-06512: at "SYS.DBMS_DATAPUMP", line 4052
ORA-06512: at line0 1]
Check log:
Errors in file /export/home/oracle/diag/rdbms/mdsets/MDSETS/trace/MDSETS_ora_224
0.trc(incident=24971):
ORA-04031: unable to allocate 56 bytes of shared memory ("streams pool","unknown
object","streams pool","fixed allocation callback")
Incident details in: /export/home/oracle/diag/rdbms/mdsets/MDSETS/incident/incdi
r_24971/MDSETS_ora_2240_i24971.trc
Wed Oct 17 09:27:44 2012
Trace dumping is performing id=[cdmp_20121017092744]
Wed Oct 17 09:27:51 2012
Sweep Incident[24971]: completed
加大streams_pool_size试着减少值shared_pool 和db_cache_size值,还是没用,只能增加streams_pool_size
增加后重新开始expdp出现
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-31626: job does not exist
ORA-31637: cannot create job SYS_EXPORT_SCHEMA_01 for user CHIMEI
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPV$FT", line 1481
ORA-39062: error creating master process DM00
ORA-39105: Master process DM00 failed during startup. Master error:
ORA-06533: Subscript. beyond count
这个错误可能是权限不够还是怎么了
之后用systme 导出可以