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
最新回复
aycmbfsbwernqts, cialis generic
cialis generic | 17/05/2012, 05:10
Mayweather vs Cotto - POST FIGHT DEBATE
RossGMoonNYC | 07/05/2012, 13:47
Hi all
I thought it would be a good idea to have somewhere to discuss the fight once its done.
So Im posting this thread with that end. If you need a link to watch the fight try: http://goo.gl/7lfcd
Alright, Let the debate begin!
Hi there! I like this forum...
bluttybow | 06/05/2012, 12:38
What day isn't today?
ALLDEAD Vokessers
Vokessers | 06/05/2012, 02:17
Hello.21.12.2012*ALLDEAD.Bye.
MSPY427]7 | 29/04/2012, 14:53
free mobile phone tracking cell phone spying software reviews cell phone spy app spy mobile.tk .
Transmission Warehouse
Boossisyraf | 29/04/2012, 01:49
At Transmission Warehouse in Las Vegas, NV, our customers come first. We provide prompt, honest transmissions services at reasonable prices. Our staff is well-trained to get you and your loved ones safely back on the road. We are the best Transmission Shop in Las Vegas! Don't hesitate to call us today for any transmission service estimate. Visit http://www.vegas-transmissionrepair.com today.
I found Best site! Wow
Srakotronos | 15/04/2012, 13:32
Very interesting site
MSPY427]7 | 13/04/2012, 06:46
computer spy software reviews spy gear ultimate spy watch spy dvr recorder
buy propecia Canada online
TizalkalkMade | 09/04/2012, 21:10
vprx
FubAnneddyWed | 08/04/2012, 16:15
vprx
vprx pills
http://www.vprxpills.com - vprx pills
buy penis pills
powermta nulled
royarpoRo | 01/04/2012, 12:59
Hey
I have powermta nulled for sale.
Good price. I provide full support , installation and mailing servers if needed.
ICQ me on 25547820
em. triggermailing @ gmail.com.
acheter propecia canada en ligne
Lypedette | 27/03/2012, 23:09
[url=http://www.prothesescapillaires.ca]achat propecia Canada en ligne[/url]
Planning to View Canada
CofsSitstit | 21/03/2012, 07:07
Hey everyone
We are thinking about to travel to Canada shortly, and I had been trying to figure out which province should I see 1st ? As I not really know if I'll be able to check each area We do not have enough ...... It is a shame
I'm more a simple guy, and I'll be with my friends.
Any advice appreciated, thanks !
Test, just a test
XRumerTest | 26/02/2012, 21:33
Hello. And Bye.
我想下载 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 | |||
aycmbfsbwernqts, cialis generic