Re: [EXP-00003: no storage definition found for segment]

From: MOHAMMAD AMER <mohammad_amer_at_usa.net>
Date: Tue, 17 Apr 2001 01:47:12 -0700
Message-ID: <F001.002EA8E4.20010417005043@fatcity.com>

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_at_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_at_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: mohammad_amer_at_usa.net

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: ListGuru_at_fatcity.com (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).

Received on Tue Apr 17 2001 - 03:47:12 CDT