create undo tbsp has error on local management tbsp syntax??

Hi All,

(I am trying to post again, I thought I post this and then I could see my own posting
for some reason. If I double post, please excuse me).

Basically, I just upgrade an oracle 8i db to 10g. I would like to create UNDO tablespace in local management tablespace and
start using the new UNDO feature instead of rollback segments. But when I run the create tablespace syntax. I got error: ERROR at line 4:
ORA-30024: Invalid specification for CREATE UNDO TABLESPACE

I did read the oracle document for the syntax chart:

Exact step:

SQL> Create UNDO Tablespace undo_tbs1
2 datafile '/qt1/q02/oradata/GA1/undotbs1.dbf' 3 size 1000M autoextend on
4 extent management local uniform size 8M; extent management local uniform size 8M
*
ERROR at line 4:
ORA-30024: Invalid specification for CREATE UNDO TABLESPACE I suspect is it oracle don't allow the UNDO tbsp to be "uniform size" ??? Or it has to be "AUTOALLOCATE" or something?
Or UNDO can't be local manage???

Am I missing something obvious??

Thanks,

Dominica Received on Thu Jul 28 2005 - 01:02:33 CDT