I have a user (user_a) in Oracle 8.1.6 EE on a Linux server and i want
to create a second user (user_b) having the same objects as user_a
(objects+data). So, i figured i could use the export and import
utilities.
I export user_a with the following command line:
exp userid=system/manager_at_thes file=user_a.dmp owner=user_a
and i get the user_a.dmp export file. To import to user_b, i use the
following command:
imp userid=system/manager_at_thes file=user_a.dmp fromuser=user_a
touser=user_b ignore=y
During the import, after all tables with their rows have been imported,
i get the following messages :
IMP-00003: ORACLE error 2270 encountered
ORA-02270: no matching unique or primary key for this column-list
Other than that, the import finishes. Browsing through user_b's objects,
i discover that all tables, instead of having primary and foreign keys,
they have unique indexes to enforce the uniqueness of the columns that
are supposed to be the primary keys.
I did a search in Metalink, but have not found any relevant information
on this one. I don't understand why this procedure fails, the export,
import and Oracle versions are all the same!
TIA,
Vasilis