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.

Answer Question   |  October 9, 2009  8:55 AM
Oracle Tables, Oracle Tablespaces

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 Blah SCCS [...]

Answer Question   |  July 23, 2009  3:44 PM
Oracle, Oracle Tables, Oracle Tablespaces

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 views. Does [...]

Answer Question   |  July 21, 2009  1:38 PM
Oracle, Oracle Table, Oracle Tablespaces

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)?

Answer Question   |  April 14, 2009  12:41 PM
Oracle 10g, Oracle Tablespaces

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

Answer Question   |  July 30, 2009  4:16 PM
Oracle administration, Oracle Tablespaces

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 [...]

Answer Question   |  February 10, 2009  5:11 PM
BLOB, Oracle Tablespaces

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.

Answer Question   |  January 22, 2008  2:15 PM
Oracle 10g, Oracle Tablespaces