OraFAQ Forum: Server Utilities » omf datafile size

Home » RDBMS Server » Server Utilities » omf datafile size

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

omf datafile size [message #155778]

Wed, 18 January 2006 09:28

vijaychauhan
Messages: 106
Registered: December 2005

Senior Member

I am using oracle 9i release 2 to create database using OMF.
The OMF takes default size of 100m for both the datafile and redologs, how can I change this size.

Report message to a moderator

Re: omf datafile size [message #155791 is a reply to message #155778]

Wed, 18 January 2006 10:29

Gerardo Fernandez Herrera
Messages: 58
Registered: January 2006
Location: Montevideo, Uruguay

Member

You have to specify the size of the datafile in the statement
CREATE TABLESPACE my_tbs DATAFILE SIZE <new_value>M;

Report message to a moderator

Re: omf datafile size [message #156071 is a reply to message #155791]

Fri, 20 January 2006 11:14

vijaychauhan
Messages: 106
Registered: December 2005

Senior Member

How can I change the size of system tablespace that i make while creating the database by running the script.I only mention the db_name, db_create_file_dest and db_create_online_log_dest_1 parameter in pfile and then startup nomount and then script is create database db_name.

Report message to a moderator

Re: omf datafile size [message #156074 is a reply to message #156071]

Fri, 20 January 2006 11:25

Gerardo Fernandez Herrera
Messages: 58
Registered: January 2006
Location: Montevideo, Uruguay

Member

Specify the DATAFILE clause in the CREATE DATABASE statement. There you can set the name, size, etc...of the system tablespace
ie:
DATAFILE '/usr/oracle/system01.dbf' size 500M autoextend on maxsize unlimited extent management local

See the SQL Reference manual for full details.

Regards.

Report message to a moderator

Re: omf datafile size [message #156313 is a reply to message #155778]

Tue, 24 January 2006 11:50

vijaychauhan
Messages: 106
Registered: December 2005

Senior Member

Thanks a lot.

Report message to a moderator

Previous Topic:	EXP/IMP - urgent please
Next Topic:	number of sysdba

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jul 02 03:56:36 CDT 2024