| ORA-12911 [message #62749] |
Wed, 11 August 2004 09:02  |
samy
Messages: 7
Registered: July 2002
|
Junior Member |
|
|
i am giving the following command and i get the errors given below. why do i get those errors and what might be the solution?
thanks in advance
alter user hanmaine temporary tablespace users;
alter user hanmaine temporary tablespace users
*
ERROR at line 1:
ORA-12911: permanent tablespace cannot be temporary tablespace
</XBODY>
|
|
|
|
| Re: ORA-12911 [message #62757 is a reply to message #62749] |
Wed, 11 August 2004 20:48  |
satyajit das
Messages: 12
Registered: August 2004
|
Junior Member |
|
|
hi
users tablespace is always a permanent tablespace. u cannot allocate a users tablespace to a user using :
alter user temporary tablespace users;
if u want to allocate temporary tablespace to a user do the following :
alter user temporary tablespace temp;
where u have to create a temporary tablespace name temp first and then allocate that temporary tablespace to that user
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
