| TEMP TABLESPACE [message #302431] |
Mon, 25 February 2008 11:24  |
sanoop_puthen
Messages: 4
Registered: February 2008
|
Junior Member |
|
|
oracle 8i in solaris os.
i created one temporary tablespace and assigned to one user, when i am trying to execute som equery it shows this error 'ora 03232 error unable to allocate an extent of 33 blocks from tablespace 2'.
For this i resized temporary tablespace same as system tablespace(previously system was the temporary tablespace for this user) but again the error repeated.
when i am changing temporary tablespace as system tablespace then it is working fine.
why it is not working when using temporary tablespace even it size is same
|
|
|
|
|
|
| Re: TEMP TABLESPACE [message #302435 is a reply to message #302431] |
Mon, 25 February 2008 11:55  |
 |
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
Are you sure this is the correct message?
Copy and paste it.
Also copy and paste the statement you execute to create the tablespace.
By the way, which 8i version?
Regards
Michel
[Updated on: Mon, 25 February 2008 11:56] Report message to a moderator |
|
|
|
| Re: TEMP TABLESPACE [message #302480 is a reply to message #302431] |
Mon, 25 February 2008 19:59 |
rhziaDBA
Messages: 17
Registered: February 2008
Location: Madrid
|
Junior Member |
|
|
PLEASE PROVIDE ME THE FOLLOWING INFORMATION
SELECT DEFAULT_TABLESPACE,TEMPORARY_TABLESPACE FROM DBA_USERS WHERE USERNAME = 'NAME OF USER'
SELECT * FROM DBA_TABLESPACES;
If the temporary tablespace of the user is not a temporary tablespace run the
ALTER USER NAMEOFUSER TEMPORARY TABLESPACE NAMEOFTABLESPACE
Regards
|
|
|
|
| Re: TEMP TABLESPACE [message #302484 is a reply to message #302480] |
Mon, 25 February 2008 21:22 |
sanoop_puthen
Messages: 4
Registered: February 2008
|
Junior Member |
|
|
>>tablespace 2 is temp or undo??
temporary tablespace
it is created using
create tempory tablespace temp tempfile '/temp.dbf' size 2900m autoextend on extent management local uniform size 4m
>>SELECT DEFAULT_TABLESPACE,TEMPORARY_TABLESPACE FROM DBA_USERS WHERE USERNAME = 'NAME OF USER'
DEFAULT_TABLESPACE=userdata
TEMPORARY_TABLESPACE=system(problem comes when i change it to temp)
[Updated on: Mon, 25 February 2008 21:31] Report message to a moderator |
|
|
|
|
|
|
|
| Re: TEMP TABLESPACE [message #302684 is a reply to message #302480] |
Tue, 26 February 2008 10:44 |
sanoop_puthen
Messages: 4
Registered: February 2008
|
Junior Member |
|
|
TABLESPACE_NAME= TEMP
INITIAL_EXTENT= 16384
NEXT_EXTENT= 16384
MIN_EXTENTS= 1
MAX_EXTENTS=
PCT_INCREASE= 0
MIN_EXTLENT= 16384
STATUS= ONLINE
CONTENTS= TEMPORARY
LOGGING= NOLOGGING
EXTENT_MAN= LOCAL
ALLOCATIO= UNIFORM
PLU= NO
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
