Home » SQL & PL/SQL » SQL & PL/SQL » About sql table
About sql table [message #21205] Thu, 18 July 2002 00:10 Go to next message
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 Go to previous message
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.
Previous Topic: About Column Width
Next Topic: Spooling takes too much time
Goto Forum:
  


Current Time: Thu Mar 28 20:32:11 CDT 2024