Size Question
Date: 31 Jan 2002 00:45:28 -0800
Message-ID: <bdb9ea8b.0201310045.224ce674_at_posting.google.com>
Hi,
A few basic questions.
Q1.
If i dont specify 'Size' clause in Create Table/TableSpace command,
What size it will take?
For Tablespace:
Assumes size of database if not specified?
For Table:
Assumes the size of tablespace if not specified?
Also, if tablesapce is created without a size clause, then table created in that tablespace will take what size?
Q2.
If you don't specify path in filespec, it will create the file in
Oracle_Home directory?
Q3.
Is there any restriction to extension of oracle data files or it could
be anything from .dat, .dbf to .asd, .plo..!!!
Q4.
If Autoextend is ON, by what amount the datafile will autogrow?
Q5.
How logical volume filling affects hard disk? e.g. HDD is 40GB.
Logical volume 'ORAL1' is 20 GB. Now, Datafile will keep autoextending
till what limit? Till hard-disk limit is reached(40 GB is full) or
till logical volume assigned(20 GB) to oracle s/w is full??
TIA Received on Thu Jan 31 2002 - 09:45:28 CET