[oracle@jilin ~]$ expdp scott/tiger dumpfile=t.dmp directory=xin schemas=scott job_name=xing;
Export: Release 10.2.0.1.0 - Production on Tuesday, 19 August, 2014 17:05:19
Copyright (c) 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
Starting "SCOTT"."XING": scott/******** dumpfile=t.dmp directory=xin schemas=scott job_name=xing
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 6 MB
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/PRE_SCHEMA/PROCACT_SCHEMA
Export> status
Job: XING
Operation: EXPORT
Mode: SCHEMA
State: EXECUTING
Bytes Processed: 4,812,360
Percent Done: 99
Current Parallelism: 1
Job Error Count: 0
Dump File: /home/oracle/t.dmp
bytes written: 4,841,472
Worker 1 Status:
State: EXECUTING
Export> stop_job
UDE-00008: operation generated ORACLE error 31623
ORA-31623: a job is not attached to this session via the specified handle
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79
ORA-06512: at "SYS.DBMS_DATAPUMP", line 911
ORA-06512: at "SYS.DBMS_DATAPUMP", line 3779
ORA-06512: at line 1
百度说是java_pool,shared_pool的设置问题
SQL> alter system set shared_pool_size = 512M scope=spfile;
System altered.
SQL> alter system set java_pool_size = 150M scope=spfile;
System altered.
SQL> alter system set aq_tm_processes = 1 scope=spfile;
System altered.
SQL> shutdown immediate
ORA-01031: insufficient privileges
SQL> conn /as sysdba
Connected.
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORA-00821: Specified value of sga_target 272M is too small, needs to be at least 672M
手动生成pfile更改sga_target后发现仍存在问题,希望大神帮参谋参谋!