Oracle 11G XE change size tablespace system

Asked

Viewed 237 times

0

I have following script:

DECLARE
  countTablespaceFile integer;

BEGIN
  SELECT count(*)
  INTO countTablespaceFile
  FROM DBA_DATA_FILES
  where file_name in ('/oracle/bdond/cbiep01/bdrgt/system01.dbf',
                    '/oracle/bdond/cbiep01/bdsirr/system01.dbf',
                    '/tmp/system02.dbf',
                    '/tmp/system03.dbf');   

  -- Nas instâncias bdrst e bdpfrl, o tablespace não pode ser criado.
  -- bdrst -> já tem o '/tmp/system02.dbf'
  -- bdpfrl -> já tem o '/tmp/system03.dbf'
  IF countTablespaceFile < 1 THEN
     execute immediate 'ALTER TABLESPACE SYSTEM add datafile ''/tmp/system02.dbf'' size 4000m';
    END IF;
END;

and then on that line I have following tablespace size error

execute 'ALTER TABLESPACE SYSTEM add datafile ''/tmp/system02.dbf'' size 4000m';

bug report:

Bug report - ORA-01119: error creating file /tmp/system02.dbf' database ORA-27040: error creating file, could not create OSD-04002 file: n Oss l open O/S-Error file: (OS 3) The system cannot find the path specified. ORA-06512: online 17 01119. 00000 - "error in Creating database file '%'" *Cause: Usually due to not having enough space on the device. *Action:

  • Question kind of obvious.. but has disk space to create a new datafile?

  • yes for sure

No answers

Browser other questions tagged

You are not signed in. Login or sign up in order to post.