Subject: Re: Tablespace Creation trouble --Help!
Newsgroups: comp.databases.oracle.misc
References:
Organization: InterAccess, Co. - Chicagoland's Full Service Internet Provider
Reply-To: akaplan@interaccess.com
Distribution:
Jason Berryhill (speck@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: <->
<-> <->
<-> www.arikaplan.com <->
<-> <->
<-> email: akaplan@interaccess.com <->
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
: ====================================================================
: =Web Site: http://www..ecst.csuchico.edu/~speck =
: =email: speck@ecst.csuchico.edu or jberryhill@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." =
: ====================================================================
:
Back to Ari Kaplan's Home Page