OraFAQ Forum: Server Administration » Tablespace Extend error

Home » RDBMS Server » Server Administration » Tablespace Extend error

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

Tablespace Extend error [message #288096]

Fri, 14 December 2007 15:37

navkrish
Messages: 189
Registered: May 2006
Location: NJ,USA

Senior Member

Hi,
I got Tablespace Extend error when i tried to insert record into table.

I know increasing tablespace or truncating data will solve this issue.

I want to know wheather deleting the records will solve or not?

Regards,
Naveen

Report message to a moderator

Re: Tablespace Extend error [message #288114 is a reply to message #288096]

Fri, 14 December 2007 22:33

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

>I got Tablespace Extend error when i tried to insert record >into table.
which tablespace permanent or temporary ?

>I want to know wheather deleting the records will solve or not?
DML statement not reset HWM.

Report message to a moderator

Re: Tablespace Extend error [message #288140 is a reply to message #288096]

Sat, 15 December 2007 01:01

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Which error did you get?

Regards
Michel

Report message to a moderator

Re: Tablespace Extend error [message #288223 is a reply to message #288096]

Sat, 15 December 2007 23:11

shahnazurs
Messages: 240
Registered: June 2005
Location: India

Senior Member

There could be different reasons when you get such error, please be specific. You could have given information like database version and release and also OS information then your error screenshot.
So that it would be helpful for anybody to resolve your problem.

Thanks,
Shahnaz.

Report message to a moderator

Re: Tablespace Extend error [message #288285 is a reply to message #288096]

Sun, 16 December 2007 22:39

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

Quote:

I know increasing tablespace or truncating data will solve this issue.

The word will be increasing data file size.

Report message to a moderator

Previous Topic:	How to remove this job?
Next Topic:	Will Drop User cascade deallocate the space.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 02 05:52:59 CST 2024