Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> create UNDO tbsp -> syntax error on extent management local uniform ???
Hi All,
Sorry, I did try to look/follow oracle's syntax diagram. And I still get an error.
And I try to do this:
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
*
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???
Thanks in advance,
Dom Received on Wed Jul 27 2005 - 21:47:55 CDT
![]() |
![]() |