EXPORT/IMPORT schema from one unix server to another?

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. Received on Wed Sep 27 2006 - 16:44:57 CDT