| Oracle datafiles [message #90463] |
Mon, 20 October 2003 08:51  |
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  |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
