Re: Tablespace Creation trouble --Help!

Jason Berryhill (speck_at_ecst.csuchico.edu) 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

Jason,

The error signifies that the COMPATIBILITY parameter in the init.ora file is set to a version too low for 7.3.0.0.0 to use. Allowing your CREATE ROLLBACK segment will make your database incompatible with whatever your init.ora is set to.

To find out what you are, look in your init.ora or type:

select * from v$parameter where name = 'compatible';

On another note, you should avoid putting your rollback segments into the SYSTEM tablespace. Make a separate rollback tablespace and put the rollback segments there.

-Ari Kaplan
Independent Oracle DBA Consultant

<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
<-> For 90+ Oracle tips, visit my Web Page:                       <->
<->                                                               <->
<->              http://homepage.interaccess.com/~akaplan         <->
<->                                                               <->
<->             email: akaplan_at_interaccess.com                    <->
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->




: ====================================================================

: =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."                                     =

: ====================================================================