Jump to content


Photo
- - - - -

Oracle Error ORA-02195


2 replies to this topic

#1 tom braider

tom braider

    Member

  • Members
  • PipPip
  • 28 posts
  • Gender:Male

Posted 23 May 2007 - 12:19 PM

Hi All,

Does anyone know about an Oracle error "ORA-02195: Attempt to create PERMANENT object in a TEMPORARY tablespace".

Is this something to do with the Oracle table sizing?

#2 Chris Mackenzie

Chris Mackenzie

    ProIV Guru

  • Members
  • PipPipPipPipPip
  • 368 posts
  • Gender:Male
  • Location:Bristol, United Kingdom

Posted 23 May 2007 - 03:42 PM

Hi All,

Does anyone know about an Oracle error "ORA-02195: Attempt to create PERMANENT object in a TEMPORARY tablespace".

Is this something to do with the Oracle table sizing?


No - I think it's even more obvious than that.
The current user probably has their default
tablespace set to temporary and is attempting
to create e.g. table or is possibly running a script
that specifies a type TEMP tablespace.
Oracle TEMP tablespace is for large sorts etc.
The content and views expressed in this message are those
of the poster and do not represent those of any organisation.

#3 tom braider

tom braider

    Member

  • Members
  • PipPip
  • 28 posts
  • Gender:Male

Posted 17 June 2007 - 04:29 PM

Hi All,

Does anyone know about an Oracle error "ORA-02195: Attempt to create PERMANENT object in a TEMPORARY tablespace".

Is this something to do with the Oracle table sizing?


No - I think it's even more obvious than that.
The current user probably has their default
tablespace set to temporary and is attempting
to create e.g. table or is possibly running a script
that specifies a type TEMP tablespace.
Oracle TEMP tablespace is for large sorts etc.


Hi Chris, It turned out that the tablespace TEMP was the default file called TEMP01.DBF and the application was looking to write to TEMP.ORA and so I renamed the TEMP to TEMP01 and then created TEMP and it worked fine. Thank you.



Reply to this topic



  


0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users