Help - imp FROMUSER= TOUSER= is driving me mad

Hi!

In Oracle 7, I try to export data from one database into another. According to the manual, that should be an easy task:

IMP system/manager FILE=expdat.dmp FROMUSER=user1 TOUSER=user2 TABLES=*

First of all, this gives a bunch of rejections due to integrity constraint violations. Oracle says, it would be a good idea to disable the constraints. True, but I don't want to do that by hand for 30 tables. Is there a flag or a command to do that for the whole database during the import process?

Second, the import starts with

. importing User1's objects into User2

then goes on for a while and suddenly changes to

	IMP-00003: ORACLE error 904 encountered
	ORA-00904: invalid column name


	. importing User1's objects into User1



                                           ^
WHY THAT ??? ------------------------------|

the whole thing ends with

. importing User1's objects into User2
        Import terminated successfully with warnings.

What's that strange user change in the import process? The only thing I want to do is to bring the objects (tables, data, etc.) from User1 on database 1 to User2 on database 2. Does anybody have an idea how to do it? All hints really welcome!

Thorsten Received on Fri Sep 16 1994 - 14:47:22 CEST