EXP-00003: no storage definition found for segment
Hi there, I have some problems to export any table, so it seems, of my Oracle 7.3.4 database. I run into the following error: EXP-3: no storage definition found for segment (name, num) Cause: Export could not find the storage definitions for a cluster, index, or table. Anybody out there who can give me a hint or workaround to export my entire database? Further explanations: I think this behavior is not caused by bug 182656. Because of this bug, the index for a primary or unique key constraint is created in a schema that is different from the table's schema. Export expects these indexes to be owned by the table owner. If it cannot find them in the owner's schema, it errors out with EXP-3. But there is definitely no index created in a schema that is different from the table's schema. Therefore the following Workarounds gives no result: - Run the export as SYS. - Disable the primary or unique key constraint, do the export, and then re-enable the constraint. - Drop the primary or unique key constraint, recreate it in the table owner's schema, and then run the export. This will actually fix the problem for the table involved. Best regards Henrik Bachmannmailto:[EMAIL PROTECTED] B.I.M.-Consulting Magdeburghttp://www.bim-consulting.de/ D-39108 Magdeburg -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bachmann, Henrik INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: [EXP-00003: no storage definition found for segment]
hi Bachman, I wonder how you could have an index that is out of your schema,you mean you built it with another user? Anyway,the workaround you wrote would do it. did you try the command prompt for export instead of using the Gui at the server? I got used to command prompts than GUI tools on the server and they are great. here is the command for the export. "exp73 userid=username/password@connect_string file=your_file_name tables=your_table_name,another_table_name,...etc". I have used exp73 because you said you are using ORacle 7.3. I issue this command from the client (if you have installed on this client the designer 2000 tool). when importing: "imp73 userid=username/password@connect_string file=your_file_name from_user=the_old_user_name to_user=the_new_user_name" these are working very fine with me. Good luck Get free email and a permanent address at http://www.netaddress.com/?N=1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MOHAMMAD AMER INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
AW: [EXP-00003: no storage definition found for segment]
Hi ... -Ursprngliche Nachricht- Von: MOHAMMAD AMER [mailto:[EMAIL PROTECTED]] Gesendet: Dienstag, 17. April 2001 10:51 An: Multiple recipients of list ORACLE-L Betreff: Re: [EXP-3: no storage definition found for segment] hi Bachman, I wonder how you could have an index that is out of your schema,you mean you built it with another user? Yes I mean that. This could be the reason for bug 182656 (Source: Oracle) Anyway,the workaround you wrote would do it. did you try the command prompt for export instead of using the Gui at the server? Yes of course. [Snip] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bachmann, Henrik INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).