Oracle Tablespaces

Data issue in a Oracle Table

I have a 180 GB size table. When I select the table,it returns some columns with null data. But if I Select that particular record showing NULL column with a Primary key filter,it is showing data for that column. Please let me know what might be the problem with that table.

Oracle- Parsing data in a specific row into a temp table

I have used select text from dba_views where owner = 'Something' and view_name = 'Something'; I get back a row with the word (MEMO) in it. However that row contains a lot of text when clicked on. Such as something like SELECT /* SCCS Rev 1.1 10/14/2002 by Blah SCCS Rev 1.2 10/24/2002 ...

Oracle- Source Code for Tables and Views cannot find

Hey, I am working on some coding to find a certain phrase with a number like (SCCS Rev 1.13) in the comments within procedures, tables, views, packages, etc. It works for everything except Tables and Views. This is because i am using Dba_source which does not include the source code for table or...

Variation in space occupied in same TABLSPACE by equally populated tables.

I am inserting data in table T2 from T1(INSERT INTO T2..SELECT..FROM T1..). Both tables are in same tablespace. Even though records in T2 are less than T1,size occupied by T2(12 GB) is much higher than T1(440 MB). WHat may be the reason(s)?

Oracle table space

how do we purge the old data in the table space of the the segment in oracle 10g?

How Do I release unused space from a tablespace after dropping a blob table

I have a 30 GB BLOB table in a 162 GB tablespace. After I used the online table reorg to move this BLOB table and its BLOB index to another tablespace, Toad tells me that I have about 35 GB free. However, I can not reduce the size of this tablespace (i.e, resize the datafiles associated with this...

10 g Temp Tablespace always shows full in OEM.

have a Oracle 10g database that is with its temporary tablespace full. Is there any way to clean this tablespace? I tried to restart the database, but i've no effect.Every day I increase the size of temp tablespace.Night we run some procedures and morning temp tablespace shows Full.