| Importing dump files questions (urgent) [message #74138] |
Sun, 19 September 2004 22:08  |
Matthew
Messages: 20
Registered: July 2001
|
Junior Member |
|
|
Hi all,
I'm using Oracle DB release 9.2 and currently i've completed a full export for a tablespace named abc. the sample of exp commands i've used :-
Computer a:exp abc_user/abc_pass full=y
I wanna now import this .dmp file into another installation of Oracle DB release 9.2 on computer b that has an exisiting tablespace also named abc with the same user name as computer a with the same roles. This user it has DBA, CONNECT and RESOURCE roles.
but it seems i can't use this username to import back the .dmpfile it keeps on giving me invalid username or password error.
i've tried even making another tablespace named abc1 with a username with imp full database role but it still cannot work.
Thanks for your time.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
