一般公司数据库的版本都一样,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博客 ” ,链接:https://blog.itpub.net/758322/viewspace-701769/ ,如需转载,请注明出处,否则将追究法律责任。