Database Reference
In-Depth Information
MAXLOGFILES 20
MAXLOGMEMBERS 20
MAXLOGHISTORY 1
MAXDATAFILES 200;
A database must have at least two redo log groups and it's
recommended that all redo log groups should be of same size.
Where we have specified 500M for system tablespace, if you use
UNLIMITED then there would not be any limit.
Actually in that case the limit comes from the space available on
your hard disk. Up till this point our database would be having
data files, control file, redo log files and obviously the PFILE.
Also we would be having SYS and SYSTEM accounts.
If you haven't changed the default password of SYS
(change_on_install) and SYSTEM (manager), it's the best time
to do it using the following ALTER USER statement.
ALTER USER username
IDENTIFIED BY password;
Data Dictionary tables would also be available but not the data
dictionary views.
Manual Database Design: Step 7
Create Additional Tablespaces
Create additional tablespaces that you need for your database
using the CREATE TABALESPACE statement e.g.,
CREATE TABLESPACE payroll LOGGING
DATAFLE '/mydatabases/mydb1/payroll.dbf' SIZE 250M
AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED
EXTENT MANGEMENT LOCAL
SEGMENT SPACE MANAGEMENT AUTO;
Create as many tablespace as you want in this manner. You can
also use ALTER TABLESPACE to add more data files to the
tablespace.
Search WWH ::
Custom Search