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).
