If the CREATE ROLLBACK SEGMENT you list is literally the one you are
using, its syntax is wrong in several ways:
- INITIAL and NEXT parameters refer to segment sizes, i.e. you need to
put a K (for Kilobytes) or M (for Megabytes) after 3 and 10240,
respectively, like you did for the OPTIMAL parameter (but without the
space between 250 and K, i.e. 250K, not 250 K).
- The MAXEXTENTS parameter is probably an illegal value. The max value
for MAXEXTENTS is 505 for 8K ORACLE block size. You can use 16K and even
32K block sizes, and maybe in those situations you may have such a high
value for MAXEXTENTS.
- PCTINCREASE parameter is not used for rollback segments.
- OPTIMAL (and *not* OPTIMAL TO) is a STORAGE parameter, i.e. its place
is before the ")", not after.
The error message you received seems a bit odd to me, though. Before
setting the COMPATIBLE parameter to the appropriate value, try using the
correct syntax and see what happens. OTOH, it is not a bad idea to set
it too, just to avoid other real problems (i.e. using 7.3.3.0.0-only
features) further down the road.
Hope this helps.
Michael Serbanescu
Jason Berryhill wrote:
>
> I hope this is an easy question:
>
> I have just set up my first ORACLE db 7.3.2.0 on HP-UX 10.10 on a
> 9000/735. The database is created. I am trying to add tablespaces. I
> used the following command to create a rollback segment first:
>
> CREATE ROLLBACK SEGMENT rbs_1
> TABLESPACE SYSTEM
> STORAGE ( INITIAL 3
> MINEXTENTS 121
> MAXEXTENTS 10240
> NEXT 10240
> PCTINCREASE 0)
> OPTIMAL TO 250 K;
>
> I receive this error message:
> CREATE ROLLBACK SEGMENT rbs_1
> *
> ORA-00406: COMPATIBLE parameter needs to be 7.3.0.0.0 or greater
>
> Does anyone know what this error message signifies? I don't have a
> reference for SQL error messages yet, and I need to get this going for my
> developers. The same message appears for when I tried to create a
> TABLESPACE. ANY help is appeciated.
>
> Thanks much,
>
> Jason Berryhill
>
> ====================================================================
> =Web Site: http://www.ecst.csuchico.edu/~speck =
> =email: speck_at_ecst.csuchico.edu or jberryhill_at_cepo.csuchico.edu =
> = =
> =BASIS Support Team. College of Business SAP R/3 class Spr 97 =
> = California State University, Chico =
> = =
> = And He looked up and saw the rich putting their gifts into the =
> =treasury. And He saw also a certain poor widow putting in two =
> =mites. So He said, "Truly I say to you that this poor widow has =
> =put in more than all; =
> = For all these out of their abundance have =
> =put in offerings to God, but she out of her poverty put in all =
> =the livelihood that she had." =
> ====================================================================
Received on Wed Jul 23 1997 - 00:00:00 CDT
