Ora-01858
Estoy intentando realizar esta operacion para auditar el server. Es un oracle 8.1.7:
INSERT INTO ZEUS_SPACES
(DB_NM,
TS,
CHECK_DATE,
COUNT_FREE_BLOCKS,
SUM_FREE_BLOCKS,
MAX_FREE_BLOCS,
SUM_FREE_BYTES)
SELECT
'FIDPROD',
TRUNC(SYSDATE),
TABLESPACE_NAME,
COUNT(BLOCKS),
SUM(BLOCKS),
MAX(BLOCKS),
SUM(BYTES)
FROM SYS.DBA_FREE_SPACE Group by TABLESPACE_NAME;
Y me está devolviendo el error ORA-01858.
Alguna sugerencia????
GRACIAS.
INSERT INTO ZEUS_SPACES
(DB_NM,
TS,
CHECK_DATE,
COUNT_FREE_BLOCKS,
SUM_FREE_BLOCKS,
MAX_FREE_BLOCS,
SUM_FREE_BYTES)
SELECT
'FIDPROD',
TRUNC(SYSDATE),
TABLESPACE_NAME,
COUNT(BLOCKS),
SUM(BLOCKS),
MAX(BLOCKS),
SUM(BYTES)
FROM SYS.DBA_FREE_SPACE Group by TABLESPACE_NAME;
Y me está devolviendo el error ORA-01858.
Alguna sugerencia????
GRACIAS.
1 Respuesta
Respuesta
1
El insert, creo que te has equivocado en el orden del tablespace y la fecha. Quedaria asi:
INSERT INTO ZEUS_SPACES
(DB_NM,
CHECK_DATE,
TS,
COUNT_FREE_BLOCKS,
SUM_FREE_BLOCKS,
MAX_FREE_BLOCS,
SUM_FREE_BYTES)
SELECT
'FIDPROD',
TRUNC(SYSDATE),
TABLESPACE_NAME,
COUNT(BLOCKS),
SUM(BLOCKS),
MAX(BLOCKS),
SUM(BYTES)
FROM SYS.DBA_FREE_SPACE Group by TABLESPACE_NAME;
INSERT INTO ZEUS_SPACES
(DB_NM,
CHECK_DATE,
TS,
COUNT_FREE_BLOCKS,
SUM_FREE_BLOCKS,
MAX_FREE_BLOCS,
SUM_FREE_BYTES)
SELECT
'FIDPROD',
TRUNC(SYSDATE),
TABLESPACE_NAME,
COUNT(BLOCKS),
SUM(BLOCKS),
MAX(BLOCKS),
SUM(BYTES)
FROM SYS.DBA_FREE_SPACE Group by TABLESPACE_NAME;