| Default Tablespaces [message #160482] |
Sun, 26 February 2006 22:02  |
gajini
Messages: 262
Registered: January 2006
|
Senior Member |
|
|
In oracle 9i,I created a database using Oracle database configuration assistant,some of the default tablespaces created for this database are
select tablespace_name from dba_tablespaces
TABLESPACE_NAME
------------------------------
SYSTEM
UNDOTBS1
TEMP
CWMLITE
DRSYS
EXAMPLE
INDX
ODM
TOOLS
USERS
XDB
But when i created the database manually using the following script,
create database NEWDB
controlfile reuse
logfile
GROUP 1 ( 'C:\oracle\oradata\newdb\log1a.rdo') SIZE 5M reuse,
GROUP 2 ( 'C:\oracle\oradata\newdb\log2a.rdo') SIZE 5M reuse,
GROUP 3 ( 'C:\oracle\oradata\newdb\log3a.rdo') SIZE 5M reuse
datafile 'C:\oracle\oradata\newdb\data01.dbf' SIZE 20M reuse
undo tablespace UNDO
datafile 'C:\oracle\oradata\newdb\undo01.dbf' SIZE 15M reuse
default temporary tablespace TEMP
tempfile 'C:\oracle\oradata\newdb\temp01.dbf ' SIZE 10M reuse
extent management local uniform size 64k
;
When i issue the same query,
select tablespace_name from dba_tablespaces
TABLESPACE_NAME
------------------------------
UNDO
TEMP
1) Why it is so?
2) Can anyone explain what are the default tablespaces get created with during database creation?
|
|
|
|
| Re: Default Tablespaces [message #160493 is a reply to message #160482] |
Sun, 26 February 2006 23:41  |
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
|
Senior Member |
|
|
At the time of Oracle installation did you choose for Installation of Oracle software + database or only oracle software?
These tablespace are included in the creation scrript for that sample default database that you did choose to create while installing Oracle.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
