合 EXP-3 No Storage Definition Found For Segment (文档 ID 443453.1)

 

0    151    1

Tags：

👉 本文共约22152个字，系统预计阅读时间或需84分钟。

EXP-3 No Storage Definition Found For Segment (文档 ID 443453.1)


In this Document

Symptoms
Cause
Solution
本页目录 隐藏
1) APPLIES TO:
2) SYMPTOMS
3) CAUSE
4) SOLUTION
5) APPLIES TO:
6) SYMPTOMS
7) CAUSE
8) SOLUTION
9) APPLIES TO:
10) PURPOSE
11) QUESTIONS AND ANSWERS
12) Enter the Main Content
13) APPLIES TO:
14) PURPOSE
15) SCOPE
16) DETAILS
16.1) 1. Known Issues with Portal Export/Import.
16.2) 2. Known Issues applying Export/Import Patches.
16.3) 1. Known Issues with Portal Export/Import.
16.3.1) 1.1 Start here.
16.3.2) 1.2 Issues running a Portal Export/Import from the Portal UI.
17) 相关文章

APPLIES TO:

Oracle Database - Enterprise Edition - Version 10.2.0.2 and later
Information in this document applies to any platform.
Checked for relevance on 16-Dec-2014

SYMPTOMS

When attempting to perform an export, the following error occurs:

EXP-00003: no storage definition found for segment(76, 66347)

CAUSE

Problem caused by an index on the object being owned by a different user.

When trying to export an object, all associated objects are exported as well. If one of the indexes is owned by a user and the exporting user does not have permissions on that index object the export fails.

SOLUTION

Redefine the index to be owned by the correct schema owner.

Error During Schema Level Export - EXP-00003: no storage definition found for segment(0, 0) (文档 ID 1969081.1)

In this Document

Symptoms
Cause
Solution

APPLIES TO:

Oracle Database - Enterprise Edition - Version 11.2.0.4 and later
Information in this document applies to any platform.

SYMPTOMS

EXP utility is showing errors while exporting schemas

EXP-00003: no storage definition found for segment(0, 0)

CAUSE

The database is on a Linux server and the Oracle database version is 11.2.0.4.

The client software is being used on a Windows client where exp is being run from version 11.2.0.1.

SOLUTION

Match the client version of the exp utility to the installed database version.

Installing the 11.2.0.4 client software on the Windows client, the error no longer occur.

NOTE:
Original Export is desupported for general use as of Oracle Database 11g. The only supported use of original Export in Oracle Database 11g is backward migration of XMLType data to Oracle Database 10g release 2 (10.2) or earlier.
Please refer to

OERR: EXP 3 "no storage definition found for segment(%lu, %lu)" (文档 ID 21599.1)

APPLIES TO:

Oracle Server - Enterprise Edition - Version 7.0.16.0 and later
Information in this document applies to any platform.

PURPOSE

Checked for relevance on 15 June 2012

QUESTIONS AND ANSWERS

Enter the Main Content

Error: EXP 3
Text: no storage definition found for segment(%lu, %lu)
-------------------------------------------------------------------------------
Cause: Export could not find the storage definitions for a cluster, index, or table.
*Action: Record the accompanying messages and report this as an Export internal error to customer support.

Diagnosis:
We could not find a storage clause for the named segment.

- The arguments above are file and block, referred to here as
F and B

- First determine what the segment is:

​ select * from dba_segments
​ where HEADER_FILE = F
​ and HEADER_BLOCK = B;

- If it is an INDEX see Bug:231159

- If it is a TABLE it may be best to run this to find table SEGMENTS
whose segment owner differs from the OBJECT owner:

​ select o.owner#, o.name, o.type#, o.namespace, s.user#
​ from obj$ o, tab$ t, seg$ s
​ where o.obj#=t.obj#
​ and t.file#=s.file#
​ and t.block#=s.block#
​ and o.owner#!=s.user#
​ ;

​ Any rows returned should be investigated.

Known Issues:
EXP 3 against Indexes / Constraints See Bug:231159

Troubleshooting Guide to Solve Common Errors with Portal Export/Import (文档 ID 364463.1)

APPLIES TO:

Portal - Version 9.0.2.2 to 11.1.1.4.0 [Release 9iASR2 to FMW11g]
Information in this document applies to any platform.
Checked for relevance on 23-Jun-2014

PURPOSE

This Note describes the most common issues reported with Portal Export/Import, their causes, and suggested actions that you may encounter while exporting and importing with OracleAS Portal.

In addition to the Support Notes below, you can get additional information here: Discussion Forums.

SCOPE

For Portal Administrators who need to migrate Portal content using Portal Export/Import utilities.

DETAILS

This document contains the following sections:

1. Known Issues with Portal Export/Import.

1.1 Start here.

1.2 Issues running a Portal Export/Import from the Portal UI.

1.3 Issues accessing the Export or Import View Logs from the Portal UI.

1.4 Issues running the Export or Import scripts from the command line.

1.5 Errors in the Export or Import Logs generated by the Export/Import script.

1.6 Errors in the Export or Import View Logs from the Portal UI.

1.7 Issues Deleting Transport Sets.

1.8 Getting Unexpected Results after Import.

2. Known Issues applying Export/Import Patches.

1. Known Issues with Portal Export/Import.

1.1 Start here.

If you have issues when doing Portal Export/Import check first the following documentation:

  • Be sure you have the latest Export/Import patches applied to both Portals (source and target).
    More Information about the latest Export/Import patches is here:

    Note 263995.1 Master Note for OracleAS Portal Export / Import Issues

  • Run the Schema Validation utility (SVU) in REPORT mode before starting a Portal Export or Import to be sure there are no inconsistencies in your portal that could cause the Export/Import to fail.

    More Information about the latest SVU patches and how to use the SVU is here:

    Note 263995.1 Master Note for OracleAS Portal Export / Import Issues
    Note 286619.1 SCHEMA VALIDATION UTILITY

  • Check your Portal meets the requirements for doing Export/Import.
    More Information about the requirements for doing Portal Export/Import is here:

    Note 308553.1 Checking your Portal meets the requirements for doing Portal Export/Import

  • Check what you are doing is supported.

    More information about supported/unsupported scenarios when using Portal Export/Import is here:

    Note 333867.1

    Portal Export/Import Supportability Guide

    And here:

    Portal VersionDocumentation
    11.1.1Oracle Fusion Middleware Administrator's Guide for Oracle Portal 11g Release 1 (11.1.1) 11.9 Recommended Best Practices When Exporting and Importing
    10.1.4Oracle Application Server Portal Configuration Guide 10g Release 2 (10.1.4) 10.4 Recommended Best Practices When Exporting and Importing
    10.1.2Oracle Application Server Portal Configuration Guide 10g Release 2 (10.1.2) 10.4 Recommended Best Practices When Exporting and Importing

  • Check the following additional documentation for documented issues.

    Portal VersionDocumentation
    11.1.1Oracle Fusion Middleware Administrator's Guide for Oracle Portal 11g Release 1 (11.1.1) Oracle Fusion Middleware Error Messages Reference 11g Release 1 (11.1.1.5.0)
    10.1.4Oracle Application Server Portal Error Messages Guide 10g Release 2 (10.1.4) Oracle Application Server Release Notes 10g Release 2 (10.1.2) for Linux x86 Oracle Application Server Portal Installation and Upgrade Guide 10g Release 2 (10.1.4)
    10.1.2Oracle Application Server Portal Error Messages Guide 10g Release 2 (10.1.2) Oracle Application Server Release Notes 10g Release 2 (10.1.2) for Linux x86

1.2 Issues running a Portal Export/Import from the Portal UI.

Unable to Export: Transport set status remains on "Export" status

Portal Version: ALL

Problem Description:

Doing an Export from the Portal UI does nothing.
The Export View log shows only the following:

Before Submitting Job for export
After Submitting Job for export

Cause:

The database parameter job_queue_processes is set to 0.
Minimum value of job_queue_processes to do Portal Export/Import is 2.
However in some environments a higher value might be required.

Fix:

Set job_queue_processes to 2 or a greater value.

References:

Note 308553.1 Checking your Portal meets the requirements for doing Portal Export/Import

Unable to Import: Transport Set Status remains on "Import"

Portal Version: ALL

Problem Description:

Doing an Import from the Portal UI does nothing.
The Import View log shows only the following:

Before Submitting Job for import
After Submitting Job for import

Cause:

The database parameter job_queue_processes is set to 0.

Minimum value of job_queue_processes to do Portal Export/Import is 2.
However in some environments a higher value might be required.

Fix:

Set job_queue_processes to 2 or a greater value.
If 2 is not enough then set to a higher value like 5 or 10.

References:

Note 308553.1 Checking your Portal meets the requirements for doing Portal Export/Import

Unable to Export or Import with security: Transport Set Status remains in Progress

Portal Version: ALL

Problem Description:

The Export Job seems to get into a loop.
The Portal database is setup to use Cost Based Optimizer (CBO).

Other symptoms:

Enabling a trace of the job session shows ORA-07445 errors while doing a query on wwpre_name$.

The following query from sqlplus as portal user returns ORA-3113 error:

select id, name from wwpre_name$
where name = 'default' or name = 'defaultmobile';

Cause:

The entire Portal schema has being analyzed to gather statistics for Performance.
Portal schema should NOT be analyzed. This is not supported.

Fix:

Ensure that there are no errant statistics in the Portal schema, issue the following command from SQL*Plus:
exec dbms_stats.delete_schema_stats(ownname=>'PORTAL');

Then use the procedure WWSBR_STATS.GATHER_STATS for managing the CBO statistics (execute as portal schema):

exec wwsbr_stats.gather_stats;

Unable to Export: Export Times Out with error "No Response from Application Web Server"

Portal Version: 10.1.4.X, 10.1.2.X, 9.0.4 , 9.0.2

Problem Description:

本人提供Oracle(OCP、OCM)、MySQL(OCP)、PostgreSQL(PGCA、PGCE、PGCM)等数据库的培训和考证业务，私聊QQ646634621或微信db_bao，谢谢！
EXP-3 No Storage Definition Found For Segment (文档 ID 443453.1)后续精彩内容已被小麦苗无情隐藏，请输入验证码解锁本站所有文章！
验证码：
请先关注本站微信公众号，然后回复“验证码”，获取验证码。在微信里搜索“DB宝”或者“www_xmmup_com”或者微信扫描右侧二维码都可以关注本站微信公众号。

标签：

Avatar photo

小麦苗

学习或考证，均可联系麦老师，请加微信db_bao或QQ646634621

您可能还喜欢...

发表回复

嘿，我是小麦，需要帮助随时找我哦。
  • 18509239930

  • 个人微信

  • DB宝
  • 个人邮箱
  • 点击加入QQ群

  • 个人微店

  • 回到顶部