Home » Infrastructure » Other Operating Systems » error while create ts on oracle z/OS (Oracle, 10g r2, z/OS 1.8)
error while create ts on oracle z/OS [message #325913] Mon, 09 June 2008 08:44 Go to next message
h.mehdi
Messages: 4
Registered: June 2008
Junior Member
Hi

I get
ORA-00604: error occurred at recursive SQL level 1                      
ORA-01655: unable to extend cluster SYS.C_TS# by 5 in tablespace SYSTEM

when I want to create a tablespace on Oracle 10g z/OS...

This is the JCL I use to create tablespace:
//ORACRTS  JOB CLASS=A,MSGCLASS=T,MSGLEVEL=(1,1),NOTIFY=&SYSUID      
//STEPAMS1 EXEC PGM=IDCAMS                                           
//SYSPRINT DD SYSOUT=*                                               
//SYSIN    DD *                                                      
   DELETE (TEST.USER.DATA)                         -                 
        CLUSTER PURGE                                                
   DEFINE CLUSTER                                  -                 
     ( LINEAR                                      -                 
      NAME(TEST.USER.DATA)                         -                 
          VOLUMES(TSTORA)                          -                 
          SHR(3 3)                                 -                 
          CYLINDERS(100 50)                        -                 
     )                                                               
//SQLPLUS  EXEC PGM=SQLPLUS,PARM='/NOLOG',REGION=0M                  
//STEPLIB  DD  DISP=SHR,DSN=ORACLE.V10202.CMDLOAD                    
//ORA$LIB  DD  DISP=SHR,DSN=ORACLE.V10202.MESG                       
//*  REQUIRES //ORA@SID  DD DUMMY STATEMENT (ORACLE INSTANCE).       
//ORA@ORA1 DD DUMMY                                                  
//ORA$ENV  DD  DISP=SHR,DSN=ORACLE.V10202.PARMLIB(ORA1ENV)  
//SQLLOGIN DD DUMMY                                         
//SYSIN    DD *                                             
connect / as sysdba                                         
CREATE TABLESPACE User_Data                                 
       DATAFILE '//TEST.USER.DATA' size 10M REUSE       
       AUTOEXTEND ON NEXT 10M;                              
/*                                                          
Re: error while create ts on oracle z/OS [message #325964 is a reply to message #325913] Mon, 09 June 2008 14:15 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Oracle
ORA-01655: unable to extend cluster string.string by string in tablespace string


Cause: Failed to allocate an extent for cluster segment in tablespace.

Action: Use ALTER TABLESPACE ADD DATAFILE statement to add one or more files to the tablespace indicated.
Re: error while create ts on oracle z/OS [message #326026 is a reply to message #325964] Mon, 09 June 2008 23:34 Go to previous messageGo to next message
h.mehdi
Messages: 4
Registered: June 2008
Junior Member
ُThanks Littlefoot but the TableSpace is not created yet...
this is what I get...
SQL> Connected.                                 
SQL>   2    3  ALTER  TABLESPACE User_Data ADD  
*                                               
ERROR at line 1:                                
ORA-00959: tablespace 'USER_DATA' does not exist

[Updated on: Mon, 09 June 2008 23:34]

Report message to a moderator

Re: error while create ts on oracle z/OS [message #326099 is a reply to message #325913] Tue, 10 June 2008 03:33 Go to previous message
h.mehdi
Messages: 4
Registered: June 2008
Junior Member
Confused
Although I'm preallocating the DATAFILE for the new TABLESPACE but it goes to create the new tablespace in SYSTEM tablespace. I don't know why...
I changed the create tablespace sql like this:
connect / as sysdba                                            
CREATE TABLESPACE usertbs 
       DATAFILE 'TEST.USER.DATA' REUSE;

but nothing changes.
Previous Topic: connectivity problem of personal oracle 8i with developer 6i
Next Topic: lbuilder on z/OS
Goto Forum:
  


Current Time: Thu Mar 28 06:34:19 CDT 2024