importing table to different table spaces [message #1016] |
Thu, 21 March 2002 01:12 |
R.SIVAKUMAR
Messages: 48 Registered: February 2002
|
Member |
|
|
hi,
i have a problem to importing records
from one table space to another table space.
i have table space name called aatable.
from that tablespace i have export some tables.
now, i want to import the tables to another
table space name called rrtable .
is it possible ?
i tried several time .
but i will show error message like
table space does not exist.
please, help me to solve this problem.
bye
siva.
|
|
|
Re: importing table to different table spaces [message #1017 is a reply to message #1016] |
Thu, 21 March 2002 01:46 |
Senthil
Messages: 68 Registered: December 1999
|
Member |
|
|
Yes...it is possible.
Make sure you have the destination tablespace(rrtable). Allocate unlimited tablespace access privilege on destination tablespace to the user who is importing. And also revoke access permission on source tablespace(aatable) to the user. That should help.
|
|
|