<div>
Hi,<br />
<br />
have a look on <a href="http://forums.oracle.com/forums/thread.jspa?threadID=953961" rel="ugc nofollow">http://forums.oracle.com/forums/thread.jspa?threadID=953961</a>
</div>


Hi,

have a look on http://forums.oracle.com/forums/thread.jspa?threadID=953961 [http://forums.oracle.com/forums/thread.jspa?threadID=953961]

<div>
I'm not aware of a way of doing this.
</div>


<div>
this is how:<br />
<a href="http://download.oracle.com/docs/cd/B19306_01/server.102/b14231/tables.htm#sthref2329" rel="ugc">http://download.oracle.com/docs/cd/B19306_01/server.102/b14231/tables.htm#sthref2329</a>
</div>


this is how:
http://download.oracle.com/docs/cd/B19306_01/server.102/b14231/tables.htm#sthref2329 [http://download.oracle.com/docs/cd/B19306_01/server.102/b14231/tables.htm#sthref2329]

<div>
Geert, that link only shows how to drop unused columns, not how to retrieve them (set them back to used) so they can be accessed again, which is what I assume Teeshirt is wanting to do.
</div>


Geert, that link only shows how to drop unused columns, not how to retrieve them (set them back to used) so they can be accessed again, which is what I assume Teeshirt is wanting to do.

<div>
setting a column to unused state is one way trip!<br />
you can not get it back.
</div>


setting a column to unused state is one way trip!
you can not get it back.

<div>
<div class="content wysiwyg-content">
How do I retrieve a column that has been 'set unused' 
</div>
</div>


How do I retrieve a column that has been 'set unused' 

oracle retreive  unused column

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.