You need to check Quota on Tablespace allocated for the user.
>>How to avoid importing on dumps original users tablespace while importing on new user?
use the fromuser, touser parameter during import
Error: ORA 1658
Text: unable to create INITIAL extent for segment in tablespace %s
Cause: Failed to find sufficient contiguous space to allocate INITIAL
extent for segment being created.
Action: Use ALTER TABLESPACE ADD DATAFILE to add additional space to the
tablespace or retry with a smaller value for INITIAL
>>You need to check Quota on Tablespace allocated for the user.
>>>>How to avoid importing on dumps original users tablespace while importing on new user?
>>use the fromuser, touser parameter during import
I did that too But still I am getting error. And my original users tablespace is getting full by that.
What to do?
Can you share you command what you are using. create new user with default tablespace command.. You can also go for the Option like first create the Object and then Import the data..
Thanks Anar Godjaev for reply
But here the problem is different. I want to avoid import of tables on other tablespace (dump files original users tablespace) instead of new users tablespace.
Can you please paste import command?
I created user first as :
CREATE USER NEW_USER IDENTIFIED BY NEW_PWD DEFAULT TABLESPACE NEW_TABLESPACE TEMPORARY TABLESPACE NEW_TEMP_TABLESPACE
QUOTA UNLIMITED ON NEW_TABLESPACE;
and then gave import command as:
imp new_user/new_pwd fromuser=olduser touser=new_user file=dump.dmp full=y log=import.log
Here NEW_TABLESPACE is tablespace for newly created new_user.
In that case first create the object on the tablespace and then import the with ignore=Y option.
DK has given you the correct approach, old style exp/imp is not very good at dealing with renaming of tablespaces. The problem is the command that gets written to the file for create table etc has a hardcoded tablespace name in it. The only way round it in old style exp/imp is to pre-create the table in the correct tablespace and then use ignore=y as DK said in his last post.
in datapump you can use remap_tablespace to do this directly in the command line - but this option isn't available in the old versions.