About sql table [message #21205] |
Thu, 18 July 2002 00:10 |
Sreenivasulu
Messages: 2 Registered: July 2002
|
Junior Member |
|
|
When we are creating a table ,before inserting any record,how much memeory allocated to table.
|
|
|
Re: About sql table [message #21224 is a reply to message #21205] |
Thu, 18 July 2002 13:21 |
andrew again
Messages: 2577 Registered: March 2000
|
Senior Member |
|
|
RAM memory and disk space in the tablespace's datafil(s) are different things. When you create a table to only uses space in the datafile (and some rows in system tables). The space consumed on disk is defined by the storage clause of the create table statement. If you don't use a storage clause (or don't specify some parameters) then the values are determined by the defaults specified for the tablespace.
Query user_tables and user_segments.
|
|
|