| Problems when exporting and importing [message #62296] |
Tue, 13 July 2004 05:55  |
VJ
Messages: 24
Registered: June 2002
|
Junior Member |
|
|
hello all,
I have a schema a in database d with default tablespace as data1 and temporary tablespace as temp1.
I want to export this schema and import it in database b where in i hav default tablespace as data2 and temporary tablespace as temp2.
when importing its giving me an error saying ..Tablespace data1 doesnt exist.
how do i fix this.. ?
Please let me know as soon as you can ...thanks in advance.
both a and b have connect and resource privileges assigned to them ..
-Vj
|
|
|
|
| Re: Problems when exporting and importing [message #62297 is a reply to message #62296] |
Tue, 13 July 2004 06:17  |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
revoke the resource priv for user B in targetDB.
and try again.
Resource priv gives righst to write to any tablespace in DB.
So, by default it may look for data1 tablespace.
create user B with data2 as default tablespace.
allocate quota unlimited on tablespace data2 for user B
do import using fromuser=a touser=b
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
