9i下EXP-0003错误解决
shadowfalao | 29 六月, 2007 11:00
在9i用exp导出clob表时，提示exp-00003错误，结果这是oracle的一个bug。见http://metalink.oracle.com Note:274076.1
这个问题是如果服务器的版本在9.2.0.5或更高，而客户端的版本低于9.2.0.5，客户端导出有BLOB/CLOB列的表时 会出现EXP-00003错误。
该问题的解决方法：(来此Metalink)
a. Make a note of the export definition of exu9tne from $ORACLE_HOME/rdbms/admin/catexp.sql
b. Copy this to a new file and add:
"UNION ALL select * from sys.exu9tneb"
to the end of the definition
e.g. In the 9.2.0.5.0 or any higher release source database (e.g. 9.2.0.6.0 or 10.1.0.4.0), the workaround view would be:
CREATE OR REPLACE VIEW exu9tne (
tsno, fileno, blockno, length) AS
SELECT ts#, segfile#, segblock#, length
FROM sys.uet$
WHERE ext# = 1
UNION ALL
SELECT * from sys.exu9tneb
/
c. Run this as the SYS user (!) against the database that needs to be exported.
d. Re-run the export as required.
e. Put back the original definition of exu9tne as obtained in step a.
Note: only use this workaround when absolutely necessary, and don't forget to put back the original definition of the view SYS.exu9tne as mentioned in step e.
在$ORACLE_HOME/rdbms/admin/catexp.sql 脚本中找到定义exu9tne的语句 ,然后将 "UNION ALL select * from sys.exu9tneb"语句加到exu9tne对象的定义脚本中，用SYS用户运行catexp.sql 脚本再执行exp导出。但在修改前最好对catexp.sql做个备份。
修改后的exu9tneb定义:
CREATE OR REPLACE VIEW exu9tne (
tsno, fileno, blockno, length) AS
SELECT ts#, segfile#, segblock#, length
FROM sys.uet$
WHERE ext# = 1
UNION ALL
SELECT * from sys.exu9tneb
/
第二种方法就是我们还可以升级客户端的版本
9
最新回复
llnaftibepxgbmbp, Health insurance online quotes, yuLixHV, Cellucor m5, MOAUTYF, african mango diet reviews, OBxPxcH, Revenge pics, UGiCnBN, Cialis and headache, vdVXBlB, Winamp icon, DhEddWg, Movie Trailers, lrfstjf, wrinkle cream, jQcUZou.
Coming soon movie trailers | 28/01/2012, 21:50
pegbbtibepxgbmbp, Healthe Trim Diet, vtlbmCc.
Healthe Trim Diet | 28/01/2012, 21:46
pegbbtibepxgbmbp, Healthe Trim Diet, vtlbmCc.
cgrkatibepxgbmbp, XtremeNO, lleFSzS, Betting blackjack wagering, XrLeqBc, Soma muscle relaxant, DPkMswI, Issues with allopurinol such as ed, yiVlmNA, Sildenafil kamagra, XnXMpbb, What software do i need to watch tv on my pc, sZoaGyr, cancer de colon, bxEyWlB, Buy Cialis, YltXOtU.
Watch tv on your pc | 28/01/2012, 21:36
cgrkatibepxgbmbp, XtremeNO, lleFSzS, Betting blackjack wagering, XrLeqBc, Soma muscle relaxant, DPkMswI, Issues with allopurinol such as ed, yiVlmNA, Sildenafil kamagra, XnXMpbb, What software do i need to watch tv on my pc, sZoaGyr, cancer de colon, bxEyWlB, Buy Cialis, YltXOtU.
yfdxdtibepxgbmbp, Cheap online say vicodin wordpress, LpOqvks, hcg, PlyHhLx, Semenax, lBQSYtB, Levitra, SQFuYev, finasteride, TuWZTIW, Nexium, vDLrKmy.
finasteride | 28/01/2012, 21:36
yfdxdtibepxgbmbp, Cheap online say vicodin wordpress, LpOqvks, hcg, PlyHhLx, Semenax, lBQSYtB, Levitra, SQFuYev, finasteride, TuWZTIW, Nexium, vDLrKmy.
flrjntibepxgbmbp, Best term life insurance quote, eEEyzDf.
Lincoln national life insurance company | 28/01/2012, 21:22
flrjntibepxgbmbp, Best term life insurance quote, eEEyzDf.
yeccstibepxgbmbp, Real time player, gOoqEGb, blu cigs reviews, NNdzGDv, Vso divx to dvd download, eCaATky, no no hair removal review, jApOJln, silk n sensepil hair removal device, iDAVAvq, Map of the world, PrQGsDc, Daylight saving time zones, BXVsUuV, luminess air, MgxxiAs.
buy no no hair removal | 28/01/2012, 21:10
yeccstibepxgbmbp, Real time player, gOoqEGb, blu cigs reviews, NNdzGDv, Vso divx to dvd download, eCaATky, no no hair removal review, jApOJln, silk n sensepil hair removal device, iDAVAvq, Map of the world, PrQGsDc, Daylight saving time zones, BXVsUuV, luminess air, MgxxiAs.
我想下载 xrumer 7.0.10 Elite?
Natashahon | 22/01/2012, 15:14
我想免费下载 XRumer 7.0.10 ??
给我的网址请!
Hello! My first post here )
unurneDuddy | 18/06/2010, 06:59
橡彗桎屙
some soap review
mybasestrr | 01/06/2010, 15:13
Greetings!
I抳e been browsing through the section for quite a long time but was feeling shy to become part of your society.
I have searched through the whole forum but still I can抰 find the answer to my issue that is why I would like to listen to your suggestions
today some new cheap sun glasses links for my friends!
sunglasses
Best Regards
Your Prada
Hi guys! Just wanted to introduce myself.
tefidionsesok | 12/05/2010, 03:55
Hi guys!
Just wanted to introduce myself.
Download gay porn movies for free! 1000s of hot gay models to choose from... muscle guys, twinks, latinos, bears, hunks...
[url=http://sexy-gay-video.com/aol-gay-chat/]aol gay chat[/url]
High quality gay porn videos at Americas favorite free gay porn tube updated daily. Tens of thousands of free hardcore gay porn movies are available to watch in high quality
The free tv shows regenesis season 4
Armand Rigot | 07/02/2010, 23:26
Elect acquaintance me if you press tv shoiws going bye bye, Thnaks
Where to 9154 tv shows
vale quetz | 07/02/2010, 14:53
If you know place where I can download tv shows coloring pages, Thanks
$100 FREE Downloads boondocks tv shows
Evangel dult | 05/02/2010, 06:52
Hello
If you need alphabetic listing of tv shows, tv ugidfe 2002 50 rgeateest shows japenese tv shows download full episodes of tv shows.
More about all a e tv shows list read fitness models in tv shows
Ifyou have any questions please contact us.
023.txt;10;15
cqweaas | 23/01/2010, 21:58
023.txt;10;15
021.txt;10;15
cqweaas | 23/01/2010, 18:50
021.txt;10;15
018.txt;10;15
cqweaas | 23/01/2010, 13:58
018.txt;10;15
006.txt;10;15
cqweaas | 22/01/2010, 18:20
006.txt;10;15
dor4.txt;10;15
cqweaas | 22/01/2010, 14:51
dor4.txt;10;15
祛耜忄 眍忸泐漤栝 漕耋
LexheerseKeme | 25/10/2009, 10:05
蔓 皴轺囫
蟒戾睃 鬣
Gypedaype | 20/10/2009, 23:27
坞
Work nice
emavarcevialp | 04/10/2008, 17:37
Hi webmaster. Good Work! :-) lol
新闻聚合
搜索
博客日历
| « | 一月 2012 | » | ||||
|---|---|---|---|---|---|---|
| 一 | 二 | 三 | 四 | 五 | 六 | 日 |
| 1 | ||||||
| 2 | 3 | 4 | 5 | 6 | 7 | 8 |
| 9 | 10 | 11 | 12 | 13 | 14 | 15 |
| 16 | 17 | 18 | 19 | 20 | 21 | 22 |
| 23 | 24 | 25 | 26 | 27 | 28 | 29 |
| 30 | 31 | |||||
llnaftibepxgbmbp, Health insurance online quotes, yuLixHV, Cellucor m5, MOAUTYF, african mango diet reviews, OBxPxcH, Revenge pics, UGiCnBN, Cialis and headache, vdVXBlB, Winamp icon, DhEddWg, Movie Trailers, lrfstjf, wrinkle cream, jQcUZou.