Home » RDBMS Server » Server Administration » Tablespace Extend error
Tablespace Extend error [message #288096] Fri, 14 December 2007 15:37 Go to next message
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

Re: Tablespace Extend error [message #288114 is a reply to message #288096] Fri, 14 December 2007 22:33 Go to previous messageGo to next message
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.

Re: Tablespace Extend error [message #288140 is a reply to message #288096] Sat, 15 December 2007 01:01 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Which error did you get?

Regards
Michel
Re: Tablespace Extend error [message #288223 is a reply to message #288096] Sat, 15 December 2007 23:11 Go to previous messageGo to next message
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.
Re: Tablespace Extend error [message #288285 is a reply to message #288096] Sun, 16 December 2007 22:39 Go to previous message
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.
Previous Topic: How to remove this job?
Next Topic: Will Drop User cascade deallocate the space.
Goto Forum:
  


Current Time: Sun Dec 04 02:16:39 CST 2016

Total time taken to generate the page: 0.07317 seconds