# DB sessions store table structure

**URL:** <https://www.ruby-forum.com/t/db-sessions-store-table-structure/130701>\
**Category:** Rails\
**Created:** [March 2, 2008, 5:17am UTC](https://www.ruby-forum.com/t/db-sessions-store-table-structure/130701 "2008-03-02T05:17:31Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![praveen\_pg](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/p/a9a28c/32.png) [@praveen\_pg](https://www.ruby-forum.com/u/praveen_pg)\
**Post date:** [March 2, 2008, 5:17am UTC](https://www.ruby-forum.com/t/db-sessions-store-table-structure/130701/1 "2008-03-02T05:17:31Z")

</div>

Hello,

I was working on a POC (proof of concept) to prove that RAILS is an  
alternative to consider for our web projects. I have enjoyed my RAILS  
experience till now. I was trying to create a sessions table in Oracle  
since I cannot create it through the migration script as it has been  
ruled out by the Database team. What is the column type for the “data”  
column in the sessions table? Would it be varchar2 or CLOB? If it is  
varchar2 what would the total size that has to be allocated? Any help  
would be appreciated.

Thanks in advance