Re: EXPORT/IMPORT schema from one unix server to another?

On 27 Sep 2006 14:44:57 -0700, floram_at_telusplanet.net wrote:

>Hello Gurus,
>
>It seems like it should be so simple. I want to export a schema from
>one unix server to another.
>
>C:\>exp myname_at_instance file=dump.dmp log=export.log owner=name
>
>C:\>imp myname_at_test_instance file=dump.dmp log=import.log fromuser=name
>touser=name_test
>
>I've already pre-created a username (name_test) and default tablespace
>in the new instance.
>
>Obviously, I am trying to recreate the schema in a test environment on
>a test server. I should be able to export the schema by specifying the
>owner in the export statement. In the import statement, I think that
>the fromuser clause refers to the owner in the export statement. The
>touser clause refers to the username that I pre-created in the new
>instance.
>
>During the import I got the following:
>
>import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character
>set
>import server uses WE8ISO8859P1 character set (possible charset
>conversion)
>. importing NAME's objects into NAME_TEST;
>IMP-00003: ORACLE error 1435 encountered
>ORA-01435: user does not exist
>Import terminated successfully with warnings.
>
>I have searched groups and web but the only solution that I could see
>was to do a full export (full=y). However, the entire instance has
>over 34 GB of data on it. There must be another way?
>
>Is there?
>
>Thank you for your help.

pre-created is too vague. It might not just have the correct priviliges. Did you actually look up error ora-1435 at all (both prior to and after posting this)
Apart from the versions, you also should always post the exact import command. Why should we assume on your behalf, your import command line was correct?

--
Sybrand Bakker, Senior Oracle DBA