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?
Click the link below to see the new game I'm developing!
2 replies to this topic
#2
Chris Mackenzie
-
- Members
-
- 372 posts
ProIV Guru
- 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.
of the poster and do not represent those of any organisation.
#3
tom braider
-
- Validating
-
- 28 posts
Member
- 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
Click the link below to see the new game I'm developing!
