What is the relationship between Tablespace and database in Oracle.
Extract from ebook material :
CREATE DATABASE TEST
GROUP 1 .......
DATAFILE 'C:\ORADATA\TEST\SYSTEM01.DBF" SIZE 500M
CREATE TABLESPACE HIST2004
DATAFILE '/ORADATA/PROD/HIST2004.DBF' SIZE 25G
To my limited knowledge in Oracle, Tablespace is existed within a database and tables and index are created under tablespace. So, what is the point of creating datafile for database ? What does it contain ?
Default database orcl is created, when I try to create a Database based on the extract of ebook above, I told me that database parameter oracl not match. Any idea ??? Does it mean that only one database is allowed in a machine ?