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.
>

  Try to modify the SHARED_POOL_SIZE, DB_BLOCK_BUFFER, DB_BLOCK_SIZE and LOG_BUFFERS. All of these parameters will affect the size of SGA.

---
Name   : Lun Wing San
Title  : Oracle Application Developer of Hong Kong Productivity Council
         Oracle Database Administrator and System Administrator of QRC
Phone  : (852)27885841