Alright...

See below...

- Kirti

-----Original Message-----
From: [Email Address Removed] [mailto:[Email Address Removed] Thursday, January 31, 2002 9:45 AM
To: LazyDBA.com Discussion
Subject: Basic Questions


Hi List,

I posted this earlier also but nobody replied to this. Kindly help me out in
this plz.

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

-->> Not of the database size..
but 5*db_block_size...
Create one and check dba_tablespaces view.

For Table:
Assumes the size of tablespace if not specified?

-->> Yes.

Also, if tablesapce is created without a size clause, then table
created in that tablespace will take what size?

-->> Defaults to whatever tablespace has.

Q2.
If you don't specify path in filespec, it will create the file in
Oracle_Home directory?

-->> Not quite.
In the $ORACLE_HOME/dbs directory.
In 9i this depends in some other init.ora parameter.
Check 9i docs for more info.

Q3.
Is there any restriction to extension of oracle data files or it could
be anything from .dat, .dbf to .asd, .plo..!!!\

-->> No.. you can use whatever you like.. my favorites are .bad .junk .crap
.bat and .exe :)


Q4.
If Autoextend is ON, by what amount the datafile will autogrow?

-->> Check the syntax. You can control the growth.

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??

-->> Till it reaches the allocated file system size.

TIA


Oracle LazyDBA home page