Home » RDBMS Server » Server Administration » unable to extend table employee
unable to extend table employee [message #213514] Thu, 11 January 2007 01:48 Go to next message
pareshr
Messages: 18
Registered: August 2006
Location: Ahmedabad
Junior Member
Hi,
I am getting this error :
IMP-00058: ORACLE error 1653 encountered
ORA-01653: unable to extend table employee by 384000 in tablespace TB_EMPLOYEE
IMP-00018: partial import of previous table completed: 4925506 rows imported


Tablespace usages for above tablespace:
NAME KBYTES USED FREE PCT_USED LARGEST
-------------------- ---------- ---------- ---------- ---------- ----------
TB_EMPLOYEE 8192000 2808196 5383804 34.2797363 1517520


Table DDL for
Create table employee(
field1..
....
)
TABLESPACE tb_event_t NOLOGGING
PCTFREE 10
PCTUSED 40
INITRANS 4
MAXTRANS 255
STORAGE (
INITIAL 1500M
NEXT 1000M
MINEXTENTS 1
MAXEXTENTS 2147483645
FREELISTS 4 FREELIST GROUPS 1 )
NOCACHE;

I am unable to find out reason for this, There is lot of space available fo TB_EMPLOYEE tablespace. Can anybody help me in this problem?


This question has been asked by some other person but I have the same query so I have posted it.

Plese if you know the reason help me out.

Paresh Rupareliya

Re: unable to extend table employee [message #213519 is a reply to message #213514] Thu, 11 January 2007 02:02 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
Oracle Version ?
and post output of below query
select bytes from dba_free_space where tablespace_name = 'TB_EMPLOYEE';


regards
Taj
Re: unable to extend table employee [message #213549 is a reply to message #213514] Thu, 11 January 2007 04:10 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Did you take your export with COMPRESS=Y (which is default)?
Then it is quite expected.
Try again with an export taken with COMPRESS=N.

[Updated on: Thu, 11 January 2007 05:13]

Report message to a moderator

Previous Topic: Ora-00600
Next Topic: listener
Goto Forum:
  


Current Time: Sun Dec 04 10:22:26 CST 2016

Total time taken to generate the page: 0.14177 seconds