Error ORA-01655: unable to extend cluster SYS.C_TS# by 3 in tablespace SYSTEM
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Error ORA-01655: unable to extend cluster SYS.C_TS# by 3 in tablespace SYSTEM

  1. #1
    Join Date
    Aug 2011
    Posts
    1

    Error ORA-01655: unable to extend cluster SYS.C_TS# by 3 in tablespace SYSTEM

    Hi,

    I have created manually database
    I want to create undo tablespace

    CREATE UNDO TABLESPACE UNDO_TABLESPACE DATAFILE 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\AJIT\UNDO_TABLESPACE.DBF' SIZE 300M

    We get an Error :
    ORA-01655: unable to extend cluster SYS.C_TS# by 3 in tablespace SYSTEM
    as serching this error on Google we get ALTER TABLESPACE ADD DATAFILE
    Please support to me that Which tablespace will add the Datafile 'SYSTEM' or only datafile


    Regards,
    Neeraj Singh

  2. #2
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,483

    Cool

    You need to increase the size of the SYSTEM tablespace by increasing the size of the existing file or adding a file to that tablespace.
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

  3. #3
    Join Date
    Aug 2011
    Posts
    3
    Thanks, Senior Advisor (LKBrwn DBA)
    It worked,

    Neeraj Singh

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