-
Temporary Tablesapce
Hi folks,
The following error i got while i created a temporary tablespace.
CREATE TEMPORARY TABLESPACE TEMP
DATAFILE 'D:\ERP\TEMP.DBF' SIZE 1000M REUSE AUTOEXTEND ON
DEFAULT STORAGE ( INITIAL 100K
NEXT 100K
MAXEXTENTS UNLIMITED
PCTINCREASE 0) ;
I got the error:
ORA-25139: invalid option for CREATE TEMPORARY TABLESPACE.
Can anyone point out whats wrong in this.
Thanx.
-
It should be TEMPFILE not DATAFILE. Your syntax is for locally managed temporary tablespace hence use extent management local uniform size 100K.
CREATE TEMPORARY TABLESPACE TEMP
TEMPFILE 'D:\ERP\TEMP.DBF' SIZE 1000M REUSE AUTOEXTEND ON
EXTENT MANGEMENT LOCAL UNIFORM SIZE 100K;
Last edited by kris109; 01-30-2004 at 01:06 AM.
Remember the Golden Rule - He who has the gold makes the rules!
===================
Kris109
Ph.D., OCP 8i, 9i, 10g, 11g DBA
-
I am getting the same error msg,, even if i changed as u said.
-
What is your database version?
SQL> CREATE TEMPORARY TABLESPACE TEMP12
TEMPFILE 'C:\oracle\oradata\junk\TEMP12.DBF' SIZE 10M REUSE
AUTOEXTEND ON EXTENT MANAGEMENT LOCAL UNIFORM SIZE 100K
Tablespace created.
Remember the Golden Rule - He who has the gold makes the rules!
===================
Kris109
Ph.D., OCP 8i, 9i, 10g, 11g DBA
-
TRY
CREATE TABLESPACE TEMP
DATAFILE 'D:\ERP\TEMP.DBF' SIZE 1000M REUSE AUTOEXTEND ON
DEFAULT STORAGE ( INITIAL 100K
NEXT 100K
MAXEXTENTS UNLIMITED
PCTINCREASE 0) TEMPORARY ;
-
Thanx Kris.
I created based on ur query and created successfully.
DB- Production 9.2
OS - Win2k.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|