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: 65144
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: error when running statspak
Next Topic: implication of alter database begin backup
Goto Forum:
  


Current Time: Sun Aug 20 20:02:03 CDT 2017

Total time taken to generate the page: 0.12423 seconds