Home » Developer & Programmer » Designer » Oracle datafiles
Oracle datafiles [message #90463] Mon, 20 October 2003 08:51 Go to next message
Omkar
Messages: 3
Registered: October 2003
Junior Member
Hi,

I have installed oracle 9i on Win 2k.

When i Create a new database by using "Database configuration assistant" it creates total 9
.dbf files.

like SYSTEM01.DBF, TOOLS01.DBF,UNDOTBS01.DBF,USERS01.DBF,TEMP01.DBF etc

what I want to know is , if i login with default user : "scoot", "tigger" and create some tables,

where is this information stored ?

if i need to create new application and assign new tablespace and users do i need to create new datafile for this?
Re: Oracle datafiles [message #90480 is a reply to message #90463] Fri, 14 November 2003 01:26 Go to previous message
bahman
Messages: 2
Registered: November 2003
Junior Member
hello mr or mrs omkar :
you should know that for every user there is a default tablespace and temporary tablespace.
default talespace for scott user is system so when you connect by scott user and create a table then records of this table will store in system tablespace but i suggest you that don't craete table in this tablespace.
to replay another your ask i said yes you should create new datafile or files for your tablespace .
bahman from iran .
bahman146@yahoo.com
Previous Topic: Why a transaction can be larger than online log?
Next Topic: Foreign key constraint on multivalued attributes
Goto Forum:
  


Current Time: Mon Mar 18 22:41:09 CDT 2024