| ORA-12911 [message #62748] |
Wed, 11 August 2004 08:57  |
samy
Messages: 7
Registered: July 2002
|
Junior Member |
|
|
alter user abc temporary tablespace users;
alter user abc temporary tablespace users
*
ERROR at line 1:
ORA-12911: permanent tablespace cannot be temporary tablespace
WHY DO I GET THIS ERROR?
thanks in advance
</XBODY>
|
|
|
|
| Re: ORA-12911 [message #62750 is a reply to message #62748] |
Wed, 11 August 2004 09:24  |
Jagdeep
Messages: 15
Registered: August 2004
|
Junior Member |
|
|
You are trying to choose a tablespace which is a Permanent tablespace. You should make a temporary tablespace and then assign it to a user.
You can try following -
Create temporary tablespace user_temp TEMPFILE '<path>' size 100M extent management local uniform size 5M;
alter user <name> temporary tablespace user_temp;
I hope this would help.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
