合 EXP-3 No Storage Definition Found For Segment (文档 ID 443453.1)
Tags: Oracle
- APPLIES TO:
- SYMPTOMS
- CAUSE
- SOLUTION
- APPLIES TO:
- SYMPTOMS
- CAUSE
- SOLUTION
- APPLIES TO:
- PURPOSE
- QUESTIONS AND ANSWERS
- Enter the Main Content
- APPLIES TO:
- PURPOSE
- SCOPE
- DETAILS
- 1. Known Issues with Portal Export/Import.
- 2. Known Issues applying Export/Import Patches.
- 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.
- REFERENCES
EXP-3 No Storage Definition Found For Segment (文档 ID 443453.1)
In this Document
Symptoms | |
---|---|
Cause | |
---|---|
Solution | |
---|---|
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.2 Issues running a Portal Export/Import from the Portal UI.
- Unable to Export: Transport set status remains on "Export" status
- Unable to Import: Transport Set Status remains on "Import"
- Unable to Export or Import with security: Transport Set Status remains in Progress
- Unable to Export: Export Times Out with error "No Response from Application Web Server"
- Portal Import Button does nothing while using a Language other than English
- Unable to Export: Get "The page cannot be found" error exporting 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.
- Error running the Import Script: Unable to Set Context for Portal User
- Running the Import Script: Importing a Transport Set to a 10.2 or later Release of the Database Hangs
1.5 Errors in the Export or Import Logs generated by the Export/Import script.
- Error in the Export log generated by the Export Script: EXP-00003 no storage definition found for segment
- Error in the Export log generated by the Export Script: EXP-6: Internal Inconsistency Error
1.6 Errors in the Export or Import View Logs from the Portal UI.
- Precheck failed for search items on import
- Error on Import: ORA-29273: HTTP request failed
- Error Importing a page group: Pre-check failed for search portlet with reference path xxxx
- Error Importing a page group: ORA-01691: unable to extend lob segment
- Error Importing a page group: wwutl_api_import_security.set_user_acl Unexpected Error: Setting User ACL
1.7 Issues Deleting Transport Sets.
1.8 Getting Unexpected Results after Import.
- After import all URLs items are pointing to the Source System
- After import all Providers are pointing to the Source System
- After Import all URLs to call your Components from a Portal DB Provider are Pointing to the Source System
- After import content Items added in the target are lost
- Users Not Getting To Their Default Home Page after Import
- Automatic_merge option has no effect during manually Page group Import on Windows platforms
- After Portal Import: Oracle Drive Doesn't Show Pages Created Through Portal UI
- Oracle Report Items do not bring the parameters after import
- Portal Surveys are missing after Import
2. Known Issues applying Export/Import Patches.
- Installing Portal patches with OPATCH on Unix environments completes successfully but the patches are not installed
- Applying a One-Off Patch On All Operating Systems Except Windows and SPARC Solaris after applying Application Server Patchset 2 (10.1.2.2)
- Unable to apply a Portal Patch with opatch : None of the patch actions is applicable to the Oracle Home
- Applying a Portal Patch with OPATCH returns the following Error: MISSING_COMPONENT : oracle.webdb, 10.1.2.0.1
- Applying a portal patch with OPATCH returns ERROR: Invalid SYS Connect Info
- Error PLS-00323 running the recompile.sql script from the latest export/import consolidated patch for 9023 (Patch:3965222)
- Error PLS-00306 applying the latest export/import consolidated patch for 9023 (Patch:3965222)
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 UTILITYCheck 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 Version Documentation 11.1.1 Oracle 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.4 Oracle Application Server Portal Configuration Guide 10g Release 2 (10.1.4) 10.4 Recommended Best Practices When Exporting and Importing 10.1.2 Oracle 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 Version Documentation 11.1.1 Oracle 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.4 Oracle 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.2 Oracle 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 exportCause:
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 importCause:
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,谢谢!