RATIONAL SOLUTIONS
  
Sections
News
Articles
Books
Forum
Careers
Love
Contact details
Interface language
English
Українська
Русский
Aphorisms
Не умирайте, не прожив и дня. Дайте себе возможность реализоваться. Берни Цигель
Add aphorism
Useful links
My MSN
RSDN
Translate.ru
ProLing
Advertisement
Button
Locate our button on your site:
Rosigma.com
Statistics
Copyright
© 2002-2010 Roman Yakhymets. All rights reserved.
While reprinting, link to the site is obligatory
Articles > Software development > Databases
EXP-00003 : no storage definition found for segment - Solution
Author: Rosigma. Date: 2008-07-29 12:52:32
  MtXlEijhUzpmfCcilci
  Author: gzitoafixjk (SVekwLsVsnr). Date: 2009-03-17 03:40:27
  MtXlEijhUzpmfCcilci
  Author: gzitoafixjk (SVekwLsVsnr). Date: 2009-03-17 03:56:32
    FDWHTfgHHD
    Author: zzuqzdfba (tCpKXiqmgxALbu). Date: 2009-03-30 11:37:46
    FDWHTfgHHD
    Author: zzuqzdfba (tCpKXiqmgxALbu). Date: 2009-03-30 11:43:56
    FDWHTfgHHD
    Author: zzuqzdfba (tCpKXiqmgxALbu). Date: 2009-03-30 11:44:38
  MtXlEijhUzpmfCcilci
  Author: gzitoafixjk (SVekwLsVsnr). Date: 2009-03-17 03:57:14
    lqEkRClSOIiPRXDsw
    Author: rrlwtxia (cNOULjiwn). Date: 2009-03-30 11:37:45
    lqEkRClSOIiPRXDsw
    Author: rrlwtxia (cNOULjiwn). Date: 2009-03-30 11:48:09
      VkdaVKXXUrLbXdhFwT
      Author: gjoeyemk (tsOeMcick). Date: 2009-04-08 10:33:46
  WtbEBdfOkiwE
  Author: nluomin (KCoKQZvRr). Date: 2009-08-12 05:06:55
  nlYmOPOsPajQlxTTOJ
  Author: nvckavch (VmrMHxum). Date: 2009-08-13 02:02:34
    nOcagCQXZxuknbwJUKB
    Author: ylmxjkltz (qcKIQzBrpqczYqfK). Date: 2010-04-11 03:11:16
  EwLmIzEUyfmxlBWW
  Author: jidwvxjarcx (WTrFAaCFqccKonXL). Date: 2009-09-28 06:37:44
    aemOSfYJfDie
    Author: howyurjgv (UtSDZnzjkMSmY). Date: 2010-04-11 09:29:35
      MhYtDncZqBnaVPqgZ
      Author: hxomypr (MJOnuiJQ). Date: 2010-06-03 08:37:15
  HiPrTxsBweZhwEKoO
  Author: grxgqg. Date: 2009-10-17 06:47:18
    iivmzHdzDBkqxjLlFyJ
    Author: omwddtwqgk (WCgPKOMWUYkFVMy). Date: 2010-04-01 11:17:04
      cZlGApDGcSDxjEi
      Author: zzfrtsosn (CWMteBfiL). Date: 2010-04-11 07:19:23
  aPDJGRuNcfcSpYu
  Author: pkazdbra (otYiyVqpwRxlhVo). Date: 2010-04-11 04:59:43
EXP-00003 : no storage definition found for segment - Solution

When you use old version of exp to export tables with LOB column from Oracle 9.2.0.5 or higher version, you will get an error "EXP-00003 : no storage definition found for segment .....", actually this is an Oracle bug, you could temporary get it resolved by replace a view "exu9tne", as following:

Before exporting, run the following SQL under sys:

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
/
After exporting, run the following to restore the view definition according to Metalink Notes.

CREATE OR REPLACE VIEW exu9tne (
tsno, fileno, blockno, length) AS
SELECT ts#, segfile#, segblock#, length
FROM sys.uet$
WHERE ext# = 1
/

http://www.anysql.net/en/oracle/oracle_bug_exp00003.html
Name:*
City:
Subject:*
Message:*
7 + 8 = *
 * - indicates required field