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

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.


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
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 .
Previous Topic: Why a transaction can be larger than online log?
Next Topic: Foreign key constraint on multivalued attributes
Goto Forum:

Current Time: Thu Mar 23 08:48:51 CDT 2023