Home » SQL & PL/SQL » SQL & PL/SQL » Reg: Table Space error...
Reg: Table Space error... [message #190427] Wed, 30 August 2006 12:02 Go to next message
sidagam
Messages: 24
Registered: February 2005
Location: Hyderabad
Junior Member
Hi All,

When i am inserting a row into 1 table which has LONG RAW table, I am getting tablespace error.
My 1st concern is that,

1.How to know how much space was allocated to the table in the tablespace and also how much memory allocated for Tablespace. I think we can know from either USER_TABLESPACES or USER_SEGMENTS. But i am not sure about which fields will tell the desired information.

2.When the tablespace error will come, how to resolve.

Awaiting your valuble response.

Thanks & Regards,

Babu SRSB.
Re: Reg: Table Space error... [message #190853 is a reply to message #190427] Fri, 01 September 2006 10:19 Go to previous messageGo to next message
sidagam
Messages: 24
Registered: February 2005
Location: Hyderabad
Junior Member
Hi Experts,

Any help or suggestions ont this above.
I am just waiting for your response.

Thanks & Regards,

Babu SRSB.
Re: Reg: Table Space error... [message #190869 is a reply to message #190427] Fri, 01 September 2006 11:32 Go to previous messageGo to next message
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
Senior Member
sidagam wrote on Wed, 30 August 2006 13:02

Hi All,

When i am inserting a row into 1 table which has LONG RAW table, I am getting tablespace error.


What is the error?
Re: Reg: Table Space error... [message #190874 is a reply to message #190427] Fri, 01 September 2006 15:01 Go to previous messageGo to next message
navkrish
Messages: 189
Registered: May 2006
Location: NJ,USA
Senior Member


you can find the bytes allocated to each tablespace...here is the link

http://www.orafaq.com/forum/t/3668/2/

have a look at below link it may help u out...
http://www.jlcomp.demon.co.uk/faq/freespace2.html


2.When the tablespace error will come, how to resolve.

increase the tablespace...u can do this by creating or increasing the size of dbf file...

Naveen

[Updated on: Fri, 01 September 2006 15:14]

Report message to a moderator

Re: Reg: Table Space error... [message #191309 is a reply to message #190874] Tue, 05 September 2006 11:15 Go to previous message
sidagam
Messages: 24
Registered: February 2005
Location: Hyderabad
Junior Member
Thank you so much Naveen.
You given nice information...

Regards,

Babu SRSB.
Previous Topic: Cursor rows to be inserted into table columns
Next Topic: error in sql script
Goto Forum:
  


Current Time: Tue Feb 11 03:39:41 CST 2025