• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 994
  • Last Modified:

LOB's and tablespace

problem:

some applications safe some data into some tables. one table use 'CLOB' as datatype.
after some time i will manually delete the records (delete from table xxx;commit;)

but: i cannot get free tablespace (tablespace that used by 'LOB' are full)

i am thinking of reorganisation of the used tables, but are there other options available?
the 'CLOB' use very much tablespace too!! are there options to safe some data (messages) more effective?


0
timemasterx
Asked:
timemasterx
1 Solution
 
seazodiacCommented:
Use truncate instead of delete.

truncate command will reclaim the data storage used by table and return them as free space to the tablespace.

SQL>truncate table <table_name>


but the above command only apply to the situation that you want to delete all the records in the table.


0
 
konektorCommented:
disable constraints before truncate and enable them afterthat (even if there are no child records)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now