| Imp command [message #72141] |
Fri, 21 March 2003 02:25  |
NG
Messages: 18
Registered: March 2003
|
Junior Member |
|
|
Will the imp command includes all the Roles into other database. But got this errors when doing the imp full database
"ORA-01917: user or role 'ETAX_SEQUENCE' does not exist"
What r the advice to solve this problem?
Do I have to manually create this role??
TIA
|
|
|
|
| Re: Imp command [message #72145 is a reply to message #72141] |
Mon, 24 March 2003 07:49  |
Uwe
Messages: 260
Registered: February 2003
Location: Zürich, Switzerland
|
Senior Member |
|
|
Hi NG
it seems so, but I guess you can also start thi imp
for one User you have an that box. But the best will be creatíng a indentical role.
regards
Uwe
|
|
|
|
| Re: Imp command [message #72149 is a reply to message #72141] |
Tue, 25 March 2003 15:50 |
Anand
Messages: 161
Registered: August 1999
|
Senior Member |
|
|
Hi,
If you do a FULL import ( ie . take an export and just dump it on to a target database by giving FULL=Y clause), you don't have to create the users individually. Import would take care of it.
But, if you are only importing a select list of schema ( using FROMUSER / TOUSER clauses), then you have to create the users and import.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
