| dominica@gmail.com 2005-07-28, 3:23 am |
| 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
|