RE: ORA-01653: unable to extend table . by in tablespace

RE: ORA-01653: unable to extend table . by in tablespace

 

  

Hi,

Thanks for your reply.

I got the solution. Actually, the tablespace in which PLAN_TABLE is
residing doesn't have enough space. I added a datafile.
Now, iam able to view the explain plan.

Thanks,
Saroja Devi.



"RajeshKumar " <oracledba-ezmlmshield-x51125854.[Email address protected]
09/29/2006 02:28 PM

To
"LazyDBA Discussion" <[Email address protected]
cc

Subject
RE: ORA-01653: unable to extend table . by in tablespace







Hi,

I think this will help you.
The tablespace the table is residing in is unable to extent.
There is not enough space left either due to the datafiles being full,
autoextend which is not set at datafile level or due to a disk which's
full.


You'll have to check the size of the datafiles attached to the
tablespace and check whether they can autoextend or not..


select file_name, bytes, autoextensible, maxbytes
from dba_data_files
where tablespace_name='TABLESPACE_NAME'


Either add more datafiles to the tablespace, set the autoextensible flag
or enlarge the datafile(s).


To add more space to a file issue following command:

alter database datafile 'C:\ORACLE\ORADATA\TOOLS01.DBF' resize 1000m;

To turn on the autoextend feature on a datafile use following command:

alter database datafile 'C:\ORACLE\ORADATA\TOOLS01.DBF' autoextend on
next 100m maxsize 2000m;

To add a new datafile to the tablespace use following command:

alter tablespace TOOLS add datafile 'C:\ORACLE\ORADATA\TOOLS02.DBF'
autoextend on next 100m maxsize 2000m;


or



try to reorg the table with smaller extent size.

with Oracle 7:
1. export tables.
2. drop table
3. recreate the table with smaller extent size
4. import the table

Thanks & Regards,

Rajesh Kumar Mathur

Techmahindra Ltd.

Sharda Center, Erandwane.

Pune (MH) - 04

Ph: +91 20 - 56018100 Ext. 1475

M : +91 9860 - 564121


-----Original Message-----
From: sarojadevi
[mailto:oracledba-ezmlmshield-x18907477.[Email address protected]

Sent: Friday, September 29, 2006 5:53 PM
To: LazyDBA Discussion
Subject: ORA-01653: unable to extend table . by in tablespace


Hi,

When i try to view the explain plan for any of the sql queries i receive

this error.

ORA-01653: unable to extend table . by in tablespace


Can any one help.

Thanks,
Saroja Devi Palani
Tata Consultancy Services Limited
Ph:- 044-66167378
Mailto: sarojadevi.[Email address protected]
Website: http://www.tcs.com
=====-----=====-----=====
Notice: The information contained in this e-mail
message and/or attachments to it may contain

confidential or privileged information. If you are

not the intended recipient, any dissemination, use,

review, distribution, printing or copying of the

information contained in this e-mail message

and/or attachments to it are strictly prohibited. If

you have received this communication in error,

please notify us by reply e-mail or telephone and

immediately and permanently delete the message

and any attachments. Thank you




---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



============================================================================================================================

Tech Mahindra, formerly Mahindra-British Telecom.


Disclaimer:

This message and the information contained herein is proprietary and
confidential and subject to the Tech Mahindra policy statement, you may
review at <a href="http://www.techmahindra.com/Disclaimer.html
">http://www.techmahindra.com/Disclaimer.html</a> externally and <a href="
http://tim.techmahindra.com/Disclaimer.html
">http://tim.techmahindra.com/Disclaimer.html</a> internally within Tech
Mahindra.

============================================================================================================================


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


ForwardSourceID:NT0000BDBA

Oracle LazyDBA home page