10G表空间传输错误

显示全部楼层 · 2012-1-4 11:51:22

[oracle@test2 ~]$ expdp trans/trans dumpfile=trans.dmp directory=dump transport_tablespaces=trans
Export: Release 10.2.0.3.0 - Production on Wednesday, 17 October, 2007 17:46:45
Copyright (c) 2003, 2005, Oracle.All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options
ORA-31626: job does not exist
ORA-31633: unable to create master table "TRANS.SYS_EXPORT_TRANSPORTABLE_05"
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPV$FT", line 863
ORA-01647: tablespace 'TRANS' is read only, cannot allocate space in it
我查了一下
SQL> show parameter process
NAME
TYPEVALUE
------------------------------------ ----------- ------------------------------
aq_tm_processes
integer 1
TRANS表空间大小是100M
ORACLE 10.2.0.3
------------------------------------------------------------------------
在10.2.0.1上也是同样的错误
求助!!!

千问 · 2012-1-4 11:51:22

expdp trans/trans dumpfile=trans.dmp directory=dump transport_tablespaces=trans这不对啊
expdp trans/trans dumpfile=trans.dmp directory=dump transport_tablespaces=y tablespaces=trans

千问 · 2012-1-4 11:51:22

http://www.eygle.com/archives/2004/06/10g_transport_tbs.html
我是参考EYGLE来做的.
这个命令9I和10G有些区别

千问 · 2012-1-4 11:51:22

语法没有问题

千问 · 2012-1-4 11:51:22

最初由 ilovemk 发布
[B]语法没有问题 [/B]
语法肯定没有问题
http://www.itpub.net/613174.html
参考了这个连接的解决办法,错误依旧!

千问 · 2012-1-4 11:51:22

换用户
trans的default tablespace 不能是要传输的表空间，因为expdp要在连接用户下创建表，而你此时的表空间是只读的

千问 · 2012-1-4 11:51:22

最初由 warehouse 发布
[B]换用户
trans的default tablespace 不能是要传输的表空间，因为expdp要在连接用户下创建表，而你此时的表空间是只读的 [/B]

谢谢warehouse ,又是个低级错误!!!

千问 · 2012-1-4 11:51:22

[oracle@test2 ~]$ expdp system/system directory=dump schemas=trans dumpfile=trans.dmp
Export: Release 10.2.0.3.0 - Production on Wednesday, 17 October, 2007 18:16:06
Copyright (c) 2003, 2005, Oracle.All rights reserved.
UDE-00008: operation generated ORACLE error 1017
ORA-01017: invalid username/password; logon denied
Username: / as sysdba
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options
FLASHBACK automatically enabled to preserve database integrity.
Starting "SYS"."SYS_EXPORT_SCHEMA_01":/******** AS SYSDBA directory=dump schemas=trans dumpfile=trans.dmp
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 64 KB
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
Processing object type SCHEMA_EXPORT/TABLE/TABLE
. . exported "TRANS"."TEST"
8.523 KB 2 rows
Master table "SYS"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SYS.SYS_EXPORT_SCHEMA_01 is:
/home/oracle/backup/trans.dmp
Job "SYS"."SYS_EXPORT_SCHEMA_01" successfully completed at 18:17:08
[oracle@test2 ~]$

千问 · 2012-1-4 11:51:22

奇怪，怎么看错误提示看不出来啊，我也试过这样，但是错误提示直接就说default tablespace 不能是要传输的表空间。。。。。

千问 · 2012-1-4 11:51:22

最初由 ilovemk 发布
[B]奇怪，怎么看错误提示看不出来啊，我也试过这样，但是错误提示直接就说default tablespace 不能是要传输的表空间。。。。。 [/B]
你的版本是多少?
我的是10203