Home » RDBMS Server » Server Utilities » imp fails from on schema to antoher
imp fails from on schema to antoher [message #71638] Sat, 07 December 2002 09:19 Go to next message
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

Report message to a moderator

Re: imp fails from on schema to antoher [message #71639 is a reply to message #71638] Sat, 07 December 2002 10:04 Go to previous message
Azim Bhanji
Messages: 2
Registered: December 2002
Junior Member
Not sure if this will help.
You might have to create a script to recreate the table in the new tablespace and use the ignore option during the import.

Report message to a moderator

Previous Topic: Date concatination to export file name on windows NT/2000
Next Topic: update statement help .... URGENT !!!
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed May 15 00:08:15 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.