-
creating temporary tablespace in oracle 7.2
I need some urgent help on creating of temporary tablespace in oracle
7.2
when i exec this statement
CREATE TABLESPACE TEMP
DATAFILE '/u03/oradata/F/TempF_01.dbf' SIZE 1950M
DEFAULT STORAGE ( INITIAL 1000M NEXT 480M MINEXTENTS 1 MAXEXTENTS
121 PCTINCREASE 0 )
TEMPORARY;
---it says invalid create tablespace statement
so I
CREATE TABLESPACE TEMP
DATAFILE '/u03/oradata/F/TempF_01.dbf' SIZE 1950M
DEFAULT STORAGE ( INITIAL 1000M NEXT 480M MINEXTENTS 1 MAXEXTENTS
121 PCTINCREASE 0 );
----without the temporary word and I am able to create
when I want to alter
alter tablespace temp temporary; ----it says invalid alter statement.
can I know what i did wrong. Please help
Regards,
Cindy
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
|