悲剧的SEQUENCE。。。。。

悲剧的SEQUENCE。。。。。

初步猜测可能是由于RAC 中手工修改sys.seq$表造成的。

但是从报错的SEQUENCE NAME

$ expdp '"hldba/azAZ123$%^"' directory=dump_dir3 logfile=exp_sales_salown061901.log dumpfile=sales_salown061901_%u.dmp schema>

Export: Release 11.2.0.2.0 - Production on Sun Jun 19 19:50:16 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, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
Starting "HLDBA"."SYS_EXPORT_SCHEMA_13": "hldba/********" directory=dump_dir3 logfile=exp_sales_salown061901.log dumpfile=sales_salown061901_%u.dmp schemas=salesmgmt,owners parallel=4 compression=all reuse_dumpfiles=y
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 2.572 GB
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/TABLESPACE_QUOTA
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.UNLOAD_METADATA [SEQUENCE:"OWNERS"."SEQ_HM_OWN_TRACK_CHG"]
ORA-22814: attribute or element value is larger than specified in type

ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPW$WORKER", line 8358

----- PL/SQL Call Stack -----
object line object
handle number name
7000005f78cf748 19208 package body SYS.KUPW$WORKER
7000005f78cf748 8385 package body SYS.KUPW$WORKER
7000005f78cf748 2935 package body SYS.KUPW$WORKER
7000005f78cf748 9054 package body SYS.KUPW$WORKER
7000005f78cf748 1688 package body SYS.KUPW$WORKER
7000005fb3ad1c8 2 anonymous block

Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.UNLOAD_METADATA [SEQUENCE:"OWNERS"."SEQ_HM_OWN_TRACK_CHG"]
ORA-22814: attribute or element value is larger than specified in type

ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPW$WORKER", line 8358

----- PL/SQL Call Stack -----
object line object
handle number name
7000005f78cf748 19208 package body SYS.KUPW$WORKER
7000005f78cf748 8385 package body SYS.KUPW$WORKER
7000005f78cf748 2935 package body SYS.KUPW$WORKER
7000005f78cf748 9054 package body SYS.KUPW$WORKER
7000005f78cf748 1688 package body SYS.KUPW$WORKER
7000005fb3ad1c8 2 anonymous block
----解决办法： DROP SEQUENCE，CREATE SEQUENCE。

--- 最原始的方法有时确实是最有效的。

select
' DROP SEQUENCE '||SEQUENCE_OWNER||'.'||SEQUENCE_NAME||' ; ' DR_SQ ,
' CREATE SEQUENCE '||SEQUENCE_OWNER||'.'||SEQUENCE_NAME||' start with '||
LAST_NUMBER|| ' increment by 1 cache 10000; ' CR_SQ ,
' GRANT SELECT ON '||SEQUENCE_OWNER||'.'||SEQUENCE_NAME||' TO SALESMGMT_OPER ; ' GR_SQ
from dba_sequences s
where s.sequence_owner = 'OWNERS'

[@more@]

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

转载于:http://blog.itpub.net/350519/viewspace-1051351/