 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussion Groups Database Servers DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybaseDesktop Databases FileMakerFoxProMS AccessParadoxGeneral General DB TopicsDatabase TheoryRelated Topics Java Development.NET DevelopmentVB DevelopmentMore Topics ... |
Database Forum / Oracle / Oracle Server / October 2008what is concept of table in Oracle
i want to know what is concept of table in Oracle?is there any relations to segment? > i want to know what is concept of table in Oracle?is there any > relations to segment? Indeed. A table is made up of segments which, in turn, are made up of extents. http://download.oracle.com/docs/cd/B19306_01/server.102/b14220/intro.htm#sthref63 HTH -g >> i want to know what is concept of table in Oracle?is there any >> relations to segment? [quoted text clipped - 7 lines] > > -g Correction. A segment is made up of extents which are made up of blocks. The only table types made up of segments are partitioned and IOT. A heap table is always a single segment.  SignatureDaniel A. Morgan Oracle Ace Director & Instructor University of Washington damorgan@x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.org > >> i want to know what is concept of table in Oracle?is there any > >> relations to segment? [quoted text clipped - 17 lines] > damor...@x.washington.edu (replace x with u to respond) > Puget Sound Oracle Users Groupwww.psoug.org Agreed. You're always far more on the ball earlier on in the day than I am, Daniel ;) -g > > >> i want to know what is concept of table in Oracle?is there any > > >> relations to segment? [quoted text clipped - 24 lines] > > - Show quoted text - It's that Starbuck's IV, I think ... <g> David Fitzjarrell >>>>> i want to know what is concept of table in Oracle?is there any >>>>> relations to segment? [quoted text clipped - 24 lines] > > David Fitzjarrell When they hear the word drip some people think: http://en.wikipedia.org/wiki/Drip_brew other think: http://en.wikipedia.org/wiki/Intravenous_therapy When you get to be my age you think: http://www.santabarbara.com/Dining/review_read.asp?pk_restaurant=1037 Why not both? One hour and I'm off to OpenWorld. And if you find your way to the right suite in the St. Regis on Thursday, at the right time, you will get to meet the "Secret Millionaire." SignatureDaniel A. Morgan Oracle Ace Director & Instructor University of Washington damorgan@x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.org > When you get to be my age you think:http://www.santabarbara.com/Dining/review_read.asp?pk_restaurant=1037 When I lived in IV we had Mr. Moustache falafels and Borsodi's for Xylophone fans. And I somehow can't quite remember the place that had the 50 cent Pabst Blue Ribbon in big plastic cups... I see zillow.com has both ms and google links to the places I lived there, amazing how little they've changed. What is concept of Under-The-Table in Oracle? :-) jg -- @home.com is bogus. And now B of A is a really big bank. http://www.leadpipeposters.com/images/0091.jpg >>>> i want to know what is concept of table in Oracle?is there any >>>> relations to segment? [quoted text clipped - 17 lines] > > -g Caffeine in the morning. Scotch in the evening. Don't get it confused. <g> SignatureDaniel A. Morgan Oracle Ace Director & Instructor University of Washington damorgan@x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.org >i want to know what is concept of table in Oracle?is there any > relations to segment? Yes a table is a type of segment. So are indexes. > i want to know what is concept of table in Oracle?is there any > relations to segment? A segment is just a thing in the database taking up physical space, such as a table, index, cluster or undo segment. Don't worry about segments. Tables on the other hand are how all data in a relational database is stored, managed, queried and presented. Asking what a table is in Oracle is rather like asking what an object is in Java, or what a pipe is in plumbing. >> i want to know what is concept of table in Oracle?is there any >> relations to segment? [quoted text clipped - 7 lines] > Oracle is rather like asking what an object is in Java, or what a pipe > is in plumbing. Agree. Much better for OP to think of a table as a purely logical thing, and forget about the physical stuff for now. To OP: Study entities/attributes/rows/tuples/relations and all the Codd stuff. Only then worry about how Oracle physically implements tables. Palooka > i want to know what is concept of table in Oracle?is there any > relations to segment? Hi if you will tolerate a post from a newbie to this group (though not a newbie to Oracle). I've often thought it is really surprising how tightly the Oracle concept of table still conforms to the concepts presented in Codd's original paper "A Relational Model of Data for Large Shared Data Banks"(CACM, vol 13, no. 6). So closely in fact that my thought is to simply point to this article and claim that for all intents and purposes that IS still the concept of table that Oracle (and every other modern RDBMS) uses. I hesitate to provide a direct link because of possible copyright issues, (though for a paper from 1970 there is probably no problem!)...but just google the title and you'll find a copy .... robert <robert@barbarian.thesecondnexus.net> wrote in news:48E93DBD.4050506 @barbarian.thesecondnexus.net: > I hesitate to provide a direct link because of possible copyright > issues, (though for a paper from 1970 there is probably no > problem!)...but just google the title and you'll find a copy .... How or why would a link violate copyrights? > robert <robert@barbarian.thesecondnexus.net> wrote in news:48E93DBD.4050506 > @barbarian.thesecondnexus.net: [quoted text clipped - 4 lines] > > How or why would a link violate copyrights? Where did I say that publishing a link violates copyright? I said there were issues. The issue is I don't want to voluntarily create any link or association between myself and those that really DO violate copyright. >> i want to know what is concept of table in Oracle?is there any >> relations to segment? [quoted text clipped - 14 lines] > (though for a paper from 1970 there is probably no problem!)...but just > google the title and you'll find a copy .... I don't think the OP was aiming at this level of conceptuality...... and note that the post was dated sept 19 and the OP never responded to any of the follow ups. Shakespeare Shakespeare |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.