Wednesday, December 28, 2011

ORA-1653: unable to extend table by 4096 in tablespace USR


[Microsoft][ODBC driver for Oracle][Oracle]ORA-20014: isincode INE683A01023Stock Details could not be Inserted. ~-1653~ORA-01653: unable to extend table LDBO.POWEROFATTORNEYSTOCKS by 4096 in tablespac

ORA-1653: unable to extend table LDBO.POWEROFATTORNEYSTOCKS by 64 in tablespace USR

ORA-1653: unable to extend table LDBO.POWEROFATTORNEYSTOCKS by 4096 in tablespace USR

ORA-01652: unable to extend temp segment by 64 in tablespace USR


Solution

Addind Datafile to existing Tablespace:


ALTER TABLESPACE usr
ADD DATAFILE 'F:\CAPD1112\USERS02.ORA' SIZE 2048M
AUTOEXTEND ON
NEXT 1024M
MAXSIZE unlimited;

No comments:

Post a Comment

Followers