ORA-25139: invalid option for CREATE TEMPORARY TABLESPACE
Sumant Renukarya (1.1k●2●33●39)
| asked Jun 24 '14, 5:54 a.m.
edited Sep 10 '14, 7:37 p.m. by Stephanie Taylor (241●1●5)
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
Hi Sumant,
Try following command:
CREATE TEMPORARY TABLESPACE RM_TEMP
TEMPFILE 'C:\OPT\Oracle\oradata\CLMDB\RM_TEMP.DBF
SIZE 1G AUTOEXTEND ON EXTENT MANAGEMENT LOCAL AUTOALLOCATE;
|
|
--> 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.
|
Your answer
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.