imp fails from on schema to antoher [message #71638] |
Sat, 07 December 2002 09:19 |
Teresa
Messages: 36 Registered: May 2002
|
Member |
|
|
Hi there
Recently I have re desing a database which 2 schemas were sharing the same tablespaces, then when I'm trying to do a import from schema a to b it fails with the following error message:
ORA-1652: unable to extend temp segment by 262144 in tablespace
TEST_BKP_DATA_TBS
which is the old schema the new schema is TEST_GURU_DATA_TBS
now I have altered the tablespace and give it more space. The export was done by TEST_BKP user and the import is by TEST_GURU user, is there anything else that I maybe missing ....
any help would be great
|
|
|
|