Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Oracle Server > Create table fo...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 13 Topic 16606 of 17418
Post > Topic >>

Create table for append only

by Andrea <netsecurity@[EMAIL PROTECTED] > May 23, 2008 at 06:04 AM

Hi guys,
sorry for my question but i would like to give some tips for create a
table in 10g database.
This table have 40 colums and start with few rows, about 2 thousand,
but it will increase soon (it appends hundred rows every day) only
through append transactions. I thinked to create a IOT table (index
organized) and maybe partition it also.

So if this kind of table has not updates but only append and select,
which are the best practices in this case?


thanks for advice
Andrew
 




 13 Posts in Topic:
Create table for append only
Andrea <netsecurity@[E  2008-05-23 06:04:10 
Re: Create table for append only
Mark D Powell <Mark.Po  2008-05-23 07:13:39 
Re: Create table for append only
"Syltrem" <s  2008-05-23 11:45:12 
Re: Create table for append only
Mark D Powell <Mark.Po  2008-05-23 07:17:50 
Re: Create table for append only
Mark D Powell <Mark.Po  2008-05-23 10:08:47 
Re: Create table for append only
madhusreeram@[EMAIL PROTE  2008-05-23 10:19:28 
Re: Create table for append only
DA Morgan <damorgan@[E  2008-05-23 10:45:40 
Re: Create table for append only
Andrea <netsecurity@[E  2008-05-26 00:47:38 
Re: Create table for append only
DA Morgan <damorgan@[E  2008-05-26 13:10:26 
Re: Create table for append only
Andrea <netsecurity@[E  2008-05-26 02:08:15 
Re: Create table for append only
Andrea <netsecurity@[E  2008-05-26 02:09:15 
Re: Create table for append only
DA Morgan <damorgan@[E  2008-05-26 14:11:44 
Re: Create table for append only
Andrea <netsecurity@[E  2008-05-27 00:04:57 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Sat Nov 22 15:46:06 CST 2008.