Re: Tablespace Creation trouble --Help!

From: Gary Assa <gsa_at_panix.com>
Date: 1997/07/29
Message-ID: <5rlbrq$74q@panix.com>#1/1

> 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
>

I don't what that error is but you should use K or M when giving values for INITIAL and NEXT. The error probably has something to do with the OPTIMAL parameter.
you also should not be creating rollback segments in SYSTEM.

-- 
                     ------------------------------------
If you have a condom and sunscreen SPF 15 or greater, than it's safe to look at
                     http://www.panix.com/~gsa/index.html

Received on Tue Jul 29 1997 - 00:00:00 CDT