Re: Tablespace Creation trouble --Help!

Jason Berryhill <speck_at_ecst.csuchico.edu> writes:

>I hope this is an easy question:

There's no such thing. ;-)

> 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

Two things you can do: set the compatible parameter in your init.ora file for this database to your db version (7.3.2.0), and bounce the dbase. Or drop the maxextents parameter in the create to 121. The error comes from Oracle protecting you (Well, the theory anyway) from being unable to downgrade the dbase, unless you specifically tell it what feature versions to go up to (as specified by the compatible parameter).

Since a db object with a maxextents of greater than 121 was not allowed until Oracle versions greater than 7.3... you get the ora-406.

Good luck!

-- 
/(o\ Nathan D. Hughes
\o)/ nhughes_at_umich.edu