Got it

hello Huawei !I get an EXP-00003 error when I use the oracle EXP tool to import data, please help me locate the issue

Created: Jul 20, 2020 03:20:47Latest reply: Jul 20, 2020 03:23:38 361 2 0 0 0
  Rewarded HiCoins: 0 (problem resolved)

I get an EXP-00003 error when I use the oracle EXP tool to import data, please help me locate the issue

Featured Answers
hello dear



When using EXP to export data by user in ORACLE, some user tables will have an error of ‘EXP-00003: no storage definition found for segment...’ and the table data export fails.
The EXP-00003: no storage definition found for segment .... error appears in the EXP log table, and the data export of the table with this error fails.
The problem is caused by a bug in ORACLE, and the view exu9tne needs to be modified
Execute the following statement:
CREATE OR REPLACE VIEW exu9tne
(tsno, fileno, blockno, length)
AS SELECT ts#, segfile#, segblock#, lengthFROM sys.uet$
WHERE ext# = 1
UNION ALL
SELECT * FROM SYS.EXU9TNEB/
Then export the data through the EXP tool can be successful
Then execute
CREATE OR REPLACE VIEW exu9tne
(tsno, fileno, blockno, length)
AS SELECT ts#, segfile#, segblock#, lengthFROM sys.uet$
WHERE ext# = 1
Restore the view back.
View more
  • x
  • convention:

All Answers
Hello, dear!
It's nice to meet you in the community.
We're working on your problem. Please be patient.
View more
  • x
  • convention:

hello dear



When using EXP to export data by user in ORACLE, some user tables will have an error of ‘EXP-00003: no storage definition found for segment...’ and the table data export fails.
The EXP-00003: no storage definition found for segment .... error appears in the EXP log table, and the data export of the table with this error fails.
The problem is caused by a bug in ORACLE, and the view exu9tne needs to be modified
Execute the following statement:
CREATE OR REPLACE VIEW exu9tne
(tsno, fileno, blockno, length)
AS SELECT ts#, segfile#, segblock#, lengthFROM sys.uet$
WHERE ext# = 1
UNION ALL
SELECT * FROM SYS.EXU9TNEB/
Then export the data through the EXP tool can be successful
Then execute
CREATE OR REPLACE VIEW exu9tne
(tsno, fileno, blockno, length)
AS SELECT ts#, segfile#, segblock#, lengthFROM sys.uet$
WHERE ext# = 1
Restore the view back.
View more
  • x
  • convention:

Comment

You need to log in to comment to the post Login | Register

Notice: To protect the legitimate rights and interests of you, the community, and third parties, do not release content that may bring legal risks to all parties, including but are not limited to the following:
  • Politically sensitive content
  • Content concerning pornography, gambling, and drug abuse
  • Content that may disclose or infringe upon others ' commercial secrets, intellectual properties, including trade marks, copyrights, and patents, and personal privacy
Do not share your account and password with others. All operations performed using your account will be regarded as your own actions and all consequences arising therefrom will be borne by you. For details, see " User Agreement."

My Followers

Login and enjoy all the member benefits

Login

Block
Are you sure to block this user?
Users on your blacklist cannot comment on your post,cannot mention you, cannot send you private messages.
Reminder
Please bind your phone number to obtain invitation bonus.