ORA-01653
Error: ORA-01653: unable to extend table string.string by string in tablespace string
Causa: Failed to allocate an extent for table segment in tablespace.
Acción: Use ALTER TABLESPACE ADD DATAFILE statement to add one or more files to the tablespace indicated.
COMENTARIOS:
por mariana | 22/03/2010 09:38:31
RE: ORA-01653
Como le hago esto es lo que me pone el error 1653
Insert into LABTRANS (LABTRANSID,TRANSDATE, LABORCODE,
REGULARHRS, OTHRS, PAYRATE, OTSCALE, STARTDATE,
STARTTIME, FINISHDATE, FINISHTIME, OUTSIDE, TRANSTYPE,
ENTERDATE, ENTERBY, MEMO, CRAFT, EQNUM, WONUM,
WPOPERATION, LineCost, LineCost2, ExchangeRate2,
GLDebitAcct, GLCreditAcct, FinancialPeriod, Location, PONum,
POLineNum, GENAPPRSERVRECEIPT, LTWO1, LTWO2, LTWO3,
LT1, LT2, LT3, LT4, LT5, LT6, LT7, LT8,LT9,LTL1, LTL2, LTL3)
Values (:cLT_LABTRANSID,SYSDATE, :cLT_LABORCODE,
:cLT_REGULARHRS, :cLT_OTHRS, :cLT_PAYRATE,
:cLT_OTSCALE, :cLT_STARTDATE, :cLT_STARTTIME,
:cLT_FINISHDATE, :cLT_FINISHTIME, :cLT_OUTSIDE,
:cLT_TRANSTYPE, :cLT_ENTERDATE, :cLT_ENTERBY,
:cLT_MEMO, :cLT_CRAFT, :cLT_EQNUM, :fWONUM,
:cLT_WPOPERATION, :cLT_LINECOST, :cLT_LINECOST2,
:cLT_EXCHANGERATE2, :cLT_GLDEBITACCT,
:cLT_GLCREDITACCT, :cLT_FINANCIALPERIOD, :cLT_LOCATION,
:cLT_PONUM, :cLT_POLINENUM, :cLT_GENAPPRSERVRECEIPT,
:cLT_LTWO1, :cLT_LTWO2, :cLT_LTWO3, :cLT1, :cLT2, :cLT3,
:cLT4, :cLT5, :cLT6, :cLT7, :cLT8,:cLT9,:cLTL1, :cLTL2, :cLTL3)
por Ingeniero Sistemas | 21/05/2012 19:00:54
RE: ORA-01653
Hey, ayuda con este error... tengo esto:
INSERT INTO AUDITORIA.A_FORMATOUNICO(
USERSO,PC,SN,OWNER,DATED,ACTION,APLICACION,
NEW_FUNNUMFOLIO,NEW_FUNFECFORMATO,NEW_FUNNOMSOLICITADO,NEW_FUNDVFUERAESPECIFICACION,NEW_FUNDVSOLCLTE,NEW_FUNDVERRORSURTIDO,
NEW_FUNDVTIEMPOENTREGA,NEW_FUNDVTARIMA,NEW_FUNDVMATERIAL,NEW_FUNDVERRORVTA,NEW_FUNRFRAZONSOCIAL,NEW_FUNRFDOMICILIOFISCAL,NEW_FUNRFRFC,NEW_FUNRFDESCPROD,NEW_FUNRFORDENCOMPRA,NEW_FUNRFCAMBIOFECHA,NEW_FUNRFDIFPRECIO,NEW_FUNOPCDVPISO,NEW_FUNOPCDVRUTA,NEW_FUNOPCNOENVIADO,NEW_FUNNCCANCELACIONSERV,NEW_FUNNCCAMBIOPRECIO,NEW_FUNDADIFPRECIO,NEW_FUNDACANCPROD,NEW_FUNAUTORIZACALIDAD,NEW_FUNGTEADMON,
NEW_FUNAUDITOR,NEW_FUNGTECXC,NEW_FUNGTEGRAL,NEW_FUNFECFV,NEW_FUNCLIENTEFV,NEW_FUNCOMENTARIOS,NEW_FUNCVEEMPRESA,NEW_FUNNUMFV,
NEW_FUNCLASEFV,NEW_FUNCVEMONEDA,NEW_FUNNUMTIPOCAMBIO,NEW_FUNNUMIMPORTE,NEW_FUNNUMIMPIVA,NEW_FUNNUMIVA,NEW_FUNNUMTOTAL,
NEW_FUNOPCDEVOLUCION,NEW_FUNOPCREFACTURACION,NEW_FUNOPCNOTACREDITO,NEW_FUNOPCDEVADMON,NEW_FUNGTESECTOR,NEW_FUNRFERRORFACTURA,
NEW_FUNRFSINIESTRO,NEW_FUNDVERRORFACT,NEW_FUNDACANCFACT,NEW_FUNNCNEGOCIOESP,NEW_FUNRFMODIFRS,NEW_FUNDIRCOMER,NEW_FUNNOMGSECTOR,
NEW_FUNBOLGSECTOR,NEW_FUNFECHORGSECTOR,NEW_FUNNOMGADMON,NEW_FUNBOLGADMON,NEW_FUNFECHORGADMON,NEW_FUNNOMAUDITOR,NEW_FUNBOLAUDITOR,NEW_FUNFECHORGAUDITOR,NEW_FUNNOMGCXC,NEW_FUNBOLGCXC,NEW_FUNFECHORGCXC,NEW_FUNNOMGGRAL,NEW_FUNBOLGGRAL,NEW_FUNFECHORGGRAL,
NEW_FUNNOMDCOMER,NEW_FUNBOLDCOMER,NEW_FUNFECHORDCOMER,NEW_FUTIPOMV,NEW_FUFOLIOMV)
VALUES(sSOUsuario,sPc,AUDITORIA.A_FORMATO.nextval,sUserOra,dFecha,'INSERT',sAplicacion,
:NEW.FUNNUMFOLIO,:NEW.FUNFECFORMATO,:NEW.FUNNOMSOLICITADO,:NEW.FUNDVFUERAESPECIFICACION,:NEW.FUNDVSOLCLTE,:NEW.FUNDVERRORSURTIDO,
:NEW.FUNDVTIEMPOENTREGA,:NEW.FUNDVTARIMA,:NEW.FUNDVMATERIAL,:NEW.FUNDVERRORVTA,:NEW.FUNRFRAZONSOCIAL,:NEW.FUNRFDOMICILIOFISCAL,:NEW.FUNRFRFC,:NEW.FUNRFDESCPROD,:NEW.FUNRFORDENCOMPRA,:NEW.FUNRFCAMBIOFECHA,:NEW.FUNRFDIFPRECIO,:NEW.FUNOPCDVPISO,:NEW.FUNOPCDVRUTA,:NEW.FUNOPCNOENVIADO,:NEW.FUNNCCANCELACIONSERV,:NEW.FUNNCCAMBIOPRECIO,:NEW.FUNDADIFPRECIO,:NEW.FUNDACANCPROD,:NEW.FUNAUTORIZACALIDAD,:NEW.FUNGTEADMON,:NEW.FUNAUDITOR,:NEW.FUNGTECXC,:NEW.FUNGTEGRAL,:NEW.FUNFECFV,:NEW.FUNCLIENTEFV,:NEW.FUNCOMENTARIOS,:NEW.FUNCVEEMPRESA,:NEW.FUNNUMFV,:NEW.FUNCLASEFV,:NEW.FUNCVEMONEDA,:NEW.FUNNUMTIPOCAMBIO,:NEW.FUNNUMIMPORTE,:NEW.FUNNUMIMPIVA,:NEW.FUNNUMIVA,:NEW.FUNNUMTOTAL,:NEW.FUNOPCDEVOLUCION,:NEW.FUNOPCREFACTURACION,:NEW.FUNOPCNOTACREDITO,:NEW.FUNOPCDEVADMON,:NEW.FUNGTESECTOR,:NEW.FUNRFERRORFACTURA,:NEW.FUNRFSINIESTRO,:NEW.FUNDVERRORFACT,:NEW.FUNDACANCFACT,:NEW.FUNNCNEGOCIOESP,:NEW.FUNRFMODIFRS,:NEW.FUNDIRCOMER,:NEW.FUNNOMGSECTOR,:NEW.FUNBOLGSECTOR,:NEW.FUNFECHORGSECTOR,:NEW.FUNNOMGADMON,:NEW.FUNBOLGADMON,:NEW.FUNFECHORGADMON,:NEW.FUNNOMAUDITOR,:NEW.FUNBOLAUDITOR,:NEW.FUNFECHORGAUDITOR,:NEW.FUNNOMGCXC,:NEW.FUNBOLGCXC,:NEW.FUNFECHORGCXC,:NEW.FUNNOMGGRAL,:NEW.FUNBOLGGRAL,:NEW.FUNFECHORGGRAL,:NEW.FUNNOMDCOMER,:NEW.FUNBOLDCOMER,:NEW.FUNFECHORDCOMER,:NEW.FUTIPOMV,:NEW.FUFOLIOMV);