Unable to extend lob segment ***_ODI_REPO.SYS_L0B000 by 1024 in tablespace ***_ODI_USER

Cause: This error usually occurs because of datafile size is completely utilized.

Solution:

1. Login to Database using putty or any tool.

[oracle@*****F-L01 ~]$ sqlplus

2. Run the below command which will get the file name for the tablespace which is throwing the error.

SQL> select file_name from dba_data_files where tablespace_name=’***_ODI_USER’;

FILE_NAME
——————————————————————————–
/u01/oradata/*****/***_odi_user.dbf

4. Now as we know the file name, now we have to run the below query to extend the size of the datafile.

SQL> alter database datafile ‘/u01/oradata/*****/***_odi_user.dbf’ autoextend on maxsize unlimited;

Note; No need to restart the database and it will resolve the problem

 

 

Advertisements

About Rahul Jain

Working as an Integration consultant AIA/SOA with around 6 years of experience in integrating, designing, developing software applications. I integrated multiple telecom solutions that include customer relationship management, Billing, Inventory management and order provisioning management system. I am Oracle SOA certified and OCA certified consultant. I am having primary experience in implementing solutions using AIA, SOA, BPEL, ESB and Product Hub for comms. Attended trainings on other Fusion Middleware products OBPMN 11g, SOA suite 11g. Involve in different phases of software Development Viz. analysis, designing, coding and testing of Modules. Also involved in implementing Oracle solution for Telco for maintaining the product catalog i.e. Oracle Product Hub for communications and integrating Oracle Product Hub with CRM and Billing applications. Using this Telco companies can maintain a single repository of all products and then publish these products to end systems with one click. Currently working on integrating Oracle EPPM Primavera with SOA/BPM/ implementation.
This entry was posted in AIA, SOA, Weblogic and tagged , , , , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s