"Rauf Sarwar" <rs_arwar_at_hotmail.com> wrote in message
news:92eeeff0.0210102121.569d7088_at_posting.google.com...
>
> Oracle documentation is cryptic when it comes to ORA-01552. I know
> that you had to create a TEMP segment in system tablespace before
> creating other non-system rollback segments in 7.3.4.x. I think this
> workaround has been a non issue since 8.x as long as tablespace is
> dictionary managed. However, it is still required on locally managed
> tablespace. I have created a few 9.2 instances recently on Win2K and
> AIX using scripts from dbca and did not have to use this workaround.
>
> Here is a test script I just ran on 8.1.7.3 (Win2K). Default is
> dictionary managed tablespace.
well what are you using those pesky DMT's for then? :(. Seriously thanks for
the correction/clarification.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
Received on Fri Oct 11 2002 - 15:07:17 CDT
