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.
============================================================================================================================
Oracle LazyDBA home page