DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: error when adding meta data to database

  1. #1
    Join Date
    Jul 2002
    Posts
    5
    hi
    i have the error message
    "unable to extend index SYS.I_OBJ1 by 5 in tablespace SYSTEM"
    when running "@?/rdbms/admin/catalog"... can anyone help me?

  2. #2
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    Maybe your system tablespace is small

  3. #3
    Join Date
    Jan 2001
    Posts
    2,828

    Talking

    Hello

    Undoubtedly your sytem tablespace is small. You can increase the size of the system tablespace by

    alter database
    resize 'complete path to system data file' resize 500M

    now again you can run those scripts..

    regards
    Hrishy

  4. #4
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    Originally posted by hrishy
    alter database
    resize 'complete path to system data file' resize 500M
    you mean

    alter database datafile

  5. #5
    Join Date
    Jan 2001
    Posts
    2,828

    Talking

    Hi Pando

    Yep you are right the correct syntax is

    alter database datafile
    'complete path to system data file' resize 500M

    regards
    Hrishy




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