| Import makes SYSTEM table owner [message #70803] |
Thu, 25 July 2002 10:16  |
Eddy Confer
Messages: 17
Registered: January 2002
|
Junior Member |
|
|
|
I am importing a dump file from a database where the table owner is fndstn. The database I am importing into also has a user called fndstn. When I import it makes SYSTEM the owner of the tables rather than fndstn. If I do an import just specifying one table and using fromuser=SYSTEM touser=FNDSTN the table is correctly assigned to FNDSTN. If I attempt to import all tables in the same manner I get a message "IMP-00034: Warning: FromUser "SYSTEM" not found in export file". My question is twofold? Why would import make SYSTEM the table owner at all? Why does the FROMUSER/TOUSER work for one table but not for all?
|
|
|
|
| Re: Import makes SYSTEM table owner [message #70804 is a reply to message #70803] |
Thu, 25 July 2002 11:08  |
Grant
Messages: 578
Registered: January 2002
|
Senior Member |
|
|
The error means SYSTEM was not the user that did the export. Try:
imp system/manager fromuser=FNDSTN touser=FNDSTN ...
If that doesn't work make an ascii file of the export and look at it with an editor. Veirfy the usernames and the tables are under that schema.
imp system/manager show=y rows=n log=textfile.log
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
