CODEWITHSUNDEEP
databaseoracle-databaseoracle11goracle10gddl
user897237
user897237

Reputation: 623

ORA-1691: unable to extend lobsegment

I'm getting this error: 

ORA-1691: unable to extend lobsegment ABC.SYS_LOB0014859757C00018$$ by 1280 in tablespace              ABC

The tablespace is build like the folowing:

CREATE TABLESPACE "ABC" DATAFILE 
  '/ora/db/user/abc1.db' SIZE 4194304000,
  '/ora/db/user/abc2.db' SIZE 4194304000,
  '/ora/db/user/abc3.db' SIZE 4194304000,
  '/ora/db/user/abc4.db' SIZE 4194304000
  LOGGING ONLINE PERMANENT BLOCKSIZE 8192
  EXTENT MANAGEMENT LOCAL UNIFORM SIZE 10485760 SEGMENT SPACE MANAGEMENT AUTO

How can I extend the tablespace? Do I need to restart db after extending?

Upvotes: 1

Views: 7027

Answers (1)

Mureinik
Mureinik

Reputation: 311188

You can extend a tablespace by adding an additional datafile to it or by extending an existing one. Since you currently seem to have a convention of uniformly sized files, I'd just add another one:

ALTER TABLESPACE "ABC" ADD DATAFILE '/ora/db/user/abc5.db' SIZE 4194304000;

This can be done with the database and tablespace online, and there's no need to restart anything.

Upvotes: 3

Related Questions