Error Creating database
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Error Creating database

  1. #1
    Join Date
    Nov 2000
    Location
    New Delhi, India
    Posts
    81
    Hi All,

    I'm trying to create Oracle 8.1.5 database on Linux 6.2, but
    it gives the following error

    ora -00604 : error occured at recursive sql level 1

    On ignoring this another error shows:

    ora 01655: unable to extendcluster sys.c_obj# by 50 in tablespace SYSTEM.

    I've specified MINEXTENT 64 and MAXEXTENTS 128 for SYSTEM tablespace. What can be done.

    Thanks in advance,

    Regards
    Shruti

  2. #2
    I dont think what you have there is a maxextents problem, more that your SYSTEM tablespace is too small. Increase the size of your system tablespace to say 200M and try again

  3. #3
    Join Date
    Nov 2000
    Location
    New Delhi, India
    Posts
    81
    Thanks a lot

    I gave the size of the SYSTEM tablespace to 10 MB and now I'm try ing with 100MB, hope it'll work.
    I'll be back if it occurs again.

    Regards
    Shruti

  4. #4
    Join Date
    May 2001
    Location
    Delhi
    Posts
    340

    System

    hi,
    yes the problem seems to be with space allocation for system tablespace.
    --------------------------
    The Time has come ....

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width