Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Importing several users
I want to migrate my application to a new Oracle 8 server. I'm using export and import, so I did the following:
1- exported my five main users to a file. This users have some grants and synonyms referencing each other objects. 2- Created this same users in the new machine (with their new default tablespaces and so on)
Now, I am going to import the file, but the imp asks me for a username. I am afraid that if I enter the system user, the imp utility might be dumb and create the objects under the system schema.
How can I tell imp to look for the correct users in the database to accommodate the incoming objets?
And if this is not possible and It's neccesary to import users one by one, how can I avoid loosing the crossed references?
Thanks.
-- Julio César Glez Suarez Xixón, Asturies, Spain jgonzalezsuareNO_at_SPAMnexo.es (Remove NO SPAM)Received on Mon Mar 20 2000 - 00:00:00 CST
![]() |
![]() |