Newbie: Easy question re. SETUP

From: Jason Berryhill <speck_at_ecst.csuchico.edu>
Date: 1997/07/21
Message-ID: <Pine.HPP.3.95.970721100603.10482A-100000@yosemite.ecst.csuchico.edu>#1/1

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 Mon Jul 21 1997 - 00:00:00 CDT