ORA-25139: invalid option for CREATE TEMPORARY TABLESPACE
I am following the procedure from interactive upgrade guide from CLM 4.0.4 to 5.0.
While creating temporary table space in Oracle DB 11G Release 11.2.0.3.0 for RM with provided command in
https://jazz.net/help-dev/clm/index.jsp?re=1&topic=/com.ibm.jazz.install.doc/topics/c_upgrade_overview.html&scope=null
sqlplus throws an syntax error.
"ERROR at line 1: ORA-25139: invalid option for CREATE TEMPORARY TABLESPACE"
-->
Command that is suggested by interactive upgrade guide:
CREATE TEMPORARY TABLESPACE RM_TEMP
DATAFILE 'ORACLE_BASE/oradata/CLMDB/RM_TEMP.DBF'
SIZE 1G AUTOEXTEND ON EXTENT MANAGEMENT LOCAL AUTOALLOCATE;
This doesn't seem to be right. Is this the correct command?
2 answers
--> Here is what I have currently for the JTS Tablespace in Oracle (on Windows):
*****
CREATE TABLESPACE jts
DATAFILE 'C:\OPT\Oracle\oradata\orcl\jts.dbf'
SIZE 1G AUTOEXTEND ON EXTENT MANAGEMENT LOCAL AUTOALLOCATE;
CREATE TEMPORARY TABLESPACE jts_t
TEMPFILE 'C:\OPT\Oracle\oradata\orcl\jts_t.dbf file'
SIZE 20M AUTOEXTEND ON EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M
*****
--> So one can use for RM tablespace in Oracle (Linux), the below entry:
***
CREATE TEMPORARY TABLESPACE RM_TEMP
TEMPFILE 'ORACLE_BASE/oradata/CLMDB/RM_TEMP.DBF
SIZE 1G AUTOEXTEND ON EXTENT MANAGEMENT LOCAL AUTOALLOCATE;
***
This above command works, doesn't throw error and looks we have a wrong documentation here for this step.