OraFAQ Forum: Other Operating Systems » error while create ts on oracle z/OS

Home » Infrastructure » Other Operating Systems » error while create ts on oracle z/OS (Oracle, 10g r2, z/OS 1.8)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

error while create ts on oracle z/OS [message #325913]

Mon, 09 June 2008 08:44

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;                              
/*

Report message to a moderator

Re: error while create ts on oracle z/OS [message #325964 is a reply to message #325913]

Mon, 09 June 2008 14:15

Littlefoot
Messages: 21823
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.

Report message to a moderator

Re: error while create ts on oracle z/OS [message #326026 is a reply to message #325964]

Mon, 09 June 2008 23:34

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

h.mehdi
Messages: 4
Registered: June 2008

Junior Member

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.

Report message to a moderator

Previous Topic:	connectivity problem of personal oracle 8i with developer 6i
Next Topic:	lbuilder on z/OS

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jan 22 03:41:14 CST 2025