ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 关于expdp/impdp、exp/imp 不常见的现象

关于expdp/impdp、exp/imp 不常见的现象

原创 Linux操作系统 作者:aaqwsh 时间:2011-07-09 20:23:51 0 删除 编辑

一般公司数据库的版本都一样,expdp/impdp、exp/imp  不会遇到版本问题。
另外数据库配置好点的话,也不会遇到ORA-04031:unable to allocate xx bytes of shared   "shared pool","streams pool"。

[oracle@db02 ~]$ exp test_user/yy tables=tab_stat file=/data/tab_stat.dmp    

Export: Release 11.2.0.2.0 - Production on Wed Jul 6 10:59:32 2011

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.


Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Export done in US7ASCII character set and UTF8 NCHAR character set
server uses UTF8 character set (possible charset conversion)

About to export specified tables via Conventional Path ...
. . exporting table                      tab_stat    1834520 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
Export terminated successfully with warnings.

[oracle@db02 data]$ expdp xx/yy tables=tab_stat directory=PUMP VERSION=10.2.0.5.0

Export: Release 11.2.0.2.0 - Production on Wed Jul 6 11:18:55 2011

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "test_user"."SYS_EXPORT_TABLE_02":  test_user/******** tables=tab_stat directory=PUMP VERSION=10.2.0.5.0
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 37 MB
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX
Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
. . exported "test_user"."tab_stat"                     29.64 MB 1834520 rows
Master table "test_user"."SYS_EXPORT_TABLE_02" successfully loaded/unloaded
******************************************************************************
Dump file set for test_user.SYS_EXPORT_TABLE_02 is:
  /data/pump/expdat.dmp
Job "test_user"."SYS_EXPORT_TABLE_02" successfully completed at 11:19:31


[oracle@testdb pump]$ impdp   \'/ as sysdba\'  tables=tab_stat directory=PUMP REMAP_SCHEMA=test_user:bb_user REMAP_TABLESPACE=ADATA:BDATA dumpfile=expdat.dmp

Import: Release 10.2.0.5.0 - 64bit Production on Wednesday, 06 July, 2011 11:29:35

Copyright (c) 2003, 2007, Oracle.  All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-31626: job does not exist
ORA-31637: cannot create job SYS_IMPORT_TABLE_01 for user SYS
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPV$FT_INT", line 672
ORA-39080: failed to create queues "KUPC$C_1_20110706112935" and "KUPC$S_1_20110706112935" for Data Pump job
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPC$QUE_INT", line 1606
ORA-04031: unable to allocate 56 bytes of shared memory ("streams pool","unknown object","streams pool","fixed allocation callback")

[oracle@testdb pump]$

SQL*Plus: Release 10.2.0.5.0 - Production on Wed Jul 6 11:31:47 2011

Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> show parameter stream;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
streams_pool_size                    big integer 0
SQL> alter system set streams_pool_size=50M;

System altered.

SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

[oracle@testdb pump]$ impdp   \'/ as sysdba\'  tables=tab_stat directory=PUMP REMAP_SCHEMA=test_user:bb_user REMAP_TABLESPACE=ADATA:BDATA dumpfile=expdat.dmp

Import: Release 10.2.0.5.0 - 64bit Production on Wednesday, 06 July, 2011 11:32:26

Copyright (c) 2003, 2007, Oracle.  All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-31626: job does not exist
ORA-31637: cannot create job SYS_IMPORT_TABLE_01 for user SYS
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPV$FT", line 1206
ORA-31621: error creating master process
ORA-04031: unable to allocate 87192 bytes of shared memory ("shared pool","unknown object","KUPP subheap","kuppcr1: bucket of kupp process descriptors")


[oracle@testdb pump]$

SQL*Plus: Release 10.2.0.5.0 - Production on Wed Jul 6 11:32:51 2011

Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> show sga

Total System Global Area 1677721600 bytes
Fixed Size                  2096792 bytes
Variable Size            1593835880 bytes
Database Buffers           67108864 bytes
Redo Buffers               14680064 bytes
SQL> show parameter shared;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
hi_shared_memory_address             integer     0
max_shared_servers                   integer
shared_memory_address                integer     0
shared_pool_reserved_size            big integer 12M
shared_pool_size                     big integer 240M
shared_server_sessions               integer
shared_servers                       integer     0
SQL> alter system set shared_pool_size=320M; 

System altered.

SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

[oracle@testdb pump]$ impdp   \'/ as sysdba\'  directory=PUMP REMAP_SCHEMA=test_user:bb_user REMAP_TABLESPACE=ADATA:BDATA dumpfile=expdat.dmp

Import: Release 10.2.0.5.0 - 64bit Production on Wednesday, 06 July, 2011 11:35:32

Copyright (c) 2003, 2007, Oracle.  All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Master table "SYS"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
Starting "SYS"."SYS_IMPORT_FULL_01":  "/******** AS SYSDBA" directory=PUMP REMAP_SCHEMA=test_user:bb_user REMAP_TABLESPACE=ADATA:BDATA dumpfile=expdat.dmp
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
. . imported "bb_user"."tab_stat"                      29.64 MB 1834520 rows
Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX
Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Job "SYS"."SYS_IMPORT_FULL_01" successfully completed at 11:35:41

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/758322/viewspace-701769/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2010-11-24

  • 博文量
    132
  • 访问量
    265296