Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Tablespace Creation trouble --Help!

Tablespace Creation trouble --Help!

From: Jason Berryhill <speck_at_ecst.csuchico.edu>
Date: 1997/07/21
Message-ID: <Pine.HPP.3.95.970721134623.12086A-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 =
Received on Mon Jul 21 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US