exp/imp problem [message #74092] |
Mon, 06 September 2004 10:50 |
jack
Messages: 123 Registered: September 2000
|
Senior Member |
|
|
I want to change user scott's objects tablespace. After changed the default tablespace, I found the old talbes still reside in system tablespace. So I export all objects of scott. The command is:
exp scott/tiger@produce file=scott.dmp log=scott.log
and create a new user scott1, whose default tablespace is users. Then I import all objects to user scott1 with command:
imp scott1/tiger@produce file=scott.dmp fromuser=scott
touser=scott1 log=scott.log
But I found some table still reside in system tablespace. Can somebody help me out?
Thanks in advance
Jack
|
|
|
|
Re: exp/imp problem [message #74097 is a reply to message #74095] |
Tue, 07 September 2004 05:43 |
jack
Messages: 123 Registered: September 2000
|
Senior Member |
|
|
I gave the new user following roles:
connect, resource
following system privileges:
create trigger, create procedure
The problem still there!
|
|
|
|
Re: exp/imp problem [message #74100 is a reply to message #74098] |
Tue, 07 September 2004 10:33 |
jack
Messages: 123 Registered: September 2000
|
Senior Member |
|
|
Hi,Mahesh. Thanks for your help. While I still have problem. After I revoked the resource role, with create trigger, create table and create procedure or not. I met error ora-01950. The import failed. Afterwards, I tried gave the new user unlimited tablespace, I got the old result that tables were imported into old tablespaces instead of a specific tablespace.
Jack
|
|
|
|
|