| How to determine size of database [message #62585] |
Sat, 31 July 2004 06:46  |
Salim
Messages: 6
Registered: May 2003
|
Junior Member |
|
|
I am working on window 2000 platform.My problem is suppose I want to create new database .How to we take what is the size of datafile ,control file , redo log file etc.
Please Help me
Salim
|
|
|
|
| Re: How to determine size of database [message #62605 is a reply to message #62585] |
Mon, 02 August 2004 22:18  |
Thomas
Messages: 67
Registered: September 1999
|
Member |
|
|
You have to specify what is the size in your "CREATE DATABASE" command. Example:
CREATE DATABASE db01
MAXINSTANCES 1
MAXLOGHISTORY 1
MAXLOGFILES 5
MAXLOGMEMBERS 3
MAXDATAFILES 100
DATAFILE 'd:oracleoradatadb01system01.dbf' SIZE 250M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL
DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE 'd:oracleoradatadb01temp01.dbf' SIZE 40M REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
UNDO TABLESPACE "UNDOTBS1" DATAFILE 'd:oracleoradatadb01undotbs01.dbf' SIZE 200M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED
CHARACTER SET WE8MSWIN1252
NATIONAL CHARACTER SET AL16UTF16
LOGFILE GROUP 1 ('d:oracleoradatadb01redo01.log') SIZE 10240K,
GROUP 2 ('d:oracleoradatadb01redo02.log') SIZE 10240K,
GROUP 3 ('d:oracleoradatadb01redo03.log') SIZE 10240K;
The number after the SIZE is what you can change.
Hope that helps,
clio_usa - OCP DBA 8/8i/9i
Oracle DBA Resources
Oracle DBA Forums
USENET Oracle newsgroups
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
