OraFAQ Forum: Server Administration » unable to extend table employee

Home » RDBMS Server » Server Administration » unable to extend table employee

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

unable to extend table employee [message #213514]

Thu, 11 January 2007 01:48

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

Report message to a moderator

Re: unable to extend table employee [message #213519 is a reply to message #213514]

Thu, 11 January 2007 02:02

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

Report message to a moderator

Re: unable to extend table employee [message #213549 is a reply to message #213514]

Thu, 11 January 2007 04:10

Mahesh Rajendran
Messages: 10707
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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 03:54:17 CDT 2024