ORA-01658: unable to create INITIAL extent for segment in tablespace USERS
S_27Feb 14 2007 — edited Feb 15 2007Hello all,
Here is the issue.
1. I exported data from X schema into a file.
2. I tried to import the same into another schema Y.
3. Now I get the ORA-01658 error message.
4. I understand that when importing the data, Y's default tablespace will not be used instead X's tablespace which is USERS is used.
5. Now, I want the import to use its own default schema and not X's (which is USERS).
6.For which I altered Y with zero quto on USERS( tablespace)
But still it is using USERS .
Will be amazing if I get a workaround for this. Am not sure how to get this done.
I know that if we add datafile it would work...however, want a solution for my import statement to use specific TABLESPACE.
Thanks!
-S