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?
– David
yes for sure
– Eduardo Sampaio