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

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.

Hmmm I do this type of thing all the time. No problems for me in my environment.

Are you working with the same or similar oracle product versions? Export and Import have some issues between releases that need attention. Received on Wed Sep 27 2006 - 17:02:00 CDT