Oracle 9i export large Oracle 10g Fields

Source: Internet
Author: User

############################ Error symptom: ###############################
The following error occurs when exporting data with 9i exp:

F: \ Oracle \ bin> exp wssw/foresee @ cradle203 file = d: \ sb_sbxx_zb.dmp tables = sb_sbxx_zb

Export: Release 9.2.0.1.0-Production on Friday May 27 11:15:24 2011

Copyright (c) 1982,200 2, Oracle Corporation. All rights reserved.


Connect to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-Production
With the Partitioning, OLAP and Data Mining options
The ZHS16GBK and AL16UTF16 NCHAR character sets have been exported.

To export the specified table, use the regular path...
... Exporting table SB_SBXX_ZB...
EXP-00003: storage definitions for segments (6,) not found
The export is successfully terminated, but a warning is displayed.

######################################## #################################


View metalink and find that this error will occur as long as the exp before 9.2.0.5 is used to export tables with LOB fields in the database after 9.2.0.5.
Solution:
1. Upgrade the client to 9.2.0.5 or above.
I used exp of 9208/10. 1.0.4 to export a table containing BLOB and CLOB. All data can be exported!

2. alternative solution:
Connect to the SYS user before export and run the following SQL:


Create or replace view exu9tne (
Tsno, fileno, blockno, length)
SELECT ts #, segfile #, segblock #, length
FROM sys. uet $
WHERE ext # = 1
UNION ALL
SELECT * from sys. EXU9TNEB

After the export is complete, restore the view (the definition can be seen through user_views). The definition of oracle9i and oracle10g is the same:

Create or replace view exu9tne (
Tsno, fileno, blockno, length)
SELECT ts #, segfile #, segblock #, length
FROM sys. uet $
WHERE ext # = 1


You can import data normally during 9i import without any errors.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.