Home » RDBMS Server » Server Administration » TEMP TABLESPACE
TEMP TABLESPACE [message #302431] Mon, 25 February 2008 11:24 Go to next message
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 #302432 is a reply to message #302431] Mon, 25 February 2008 11:44 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
tablespace 2 is temp or undo??
Re: TEMP TABLESPACE [message #302435 is a reply to message #302431] Mon, 25 February 2008 11:55 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 #302510 is a reply to message #302484] Tue, 26 February 2008 00:10 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You must copy and paste the queries you make on dictionary and their result not rewrite them.
You must answer all the questions we ask.

Regards
Michel
Re: TEMP TABLESPACE [message #302537 is a reply to message #302510] Tue, 26 February 2008 01:19 Go to previous messageGo to next message
sanoop_puthen
Messages: 4
Registered: February 2008
Junior Member
Sorry for the trouble. DB is in a unix machine which i dont have internet.
Re: TEMP TABLESPACE [message #302684 is a reply to message #302480] Tue, 26 February 2008 10:44 Go to previous message
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
Previous Topic: Not able to login remotely with my sys acct after upgrade only locally
Next Topic: Find host name for oracle database
Goto Forum:
  


Current Time: Sun Dec 04 18:55:41 CST 2016

Total time taken to generate the page: 0.08615 seconds