Re: Database creation problem

Mahesh T. Kumar wrote:
>
> I am trying to create a sample database with 2 tables. I have setup my init.ora & config.ora files.
> I am also creating 1 public & 3 private rollback segments. I have tablespaces defined in the
> script,on which I'm creating these objects. The problem is, the process fails in the middle with
> an error message "error in memory allocation- malloc error"(may not be in exact words). I have
> tried creating this database numerous times. Everytime, this error message is generated by
> different statement. This time it was generated by "create rollback segment". On previous
> occasions, it was either "create tablespace" or "create table". I have played around with sizes of
> these objects, datafile and other attributes of these objects. So far I am not been able to get
> right combination of all these parameters. I am starting to suspect my parameters in the init &
> config files. I am using the copies of the default one's.
>
> Thanks in advance for any tips and suggestions.

It sounds a lot like a memory problem. Check your hard and soft limits for memory. Stuff like stacksize, datasize, memoryuse and whatever the coresponding hard limits would be. The best thing to would be to call your operating system vendor and have them tell you how to increase these.

The fact that it happens on a different statement each time points to a memory allocation problem. At least the "malloc" error certainly points to memory problems. Received on Sun Jan 26 1997 - 00:00:00 CST