Home » RDBMS Server » Server Administration » problem with size during database creation (Oracle 11.2.0.2, AIX)
problem with size during database creation [message #547782] Fri, 16 March 2012 10:11 Go to next message
lg123
Messages: 225
Registered: August 2008
Senior Member
I guess by default, oracle is creating the database using DBCA method with size 2 GB. If I want the database size to be 300 GB, what should I do?

Report message to a moderator

Re: problem with size during database creation [message #547783 is a reply to message #547782] Fri, 16 March 2012 10:13 Go to previous messageGo to next message
cookiemonster
Messages: 13965
Registered: September 2008
Location: Rainy Manchester
Senior Member
Databases don't have a size as such. Particular components do.
Which bits do you want to make 300G?
Do just need to add some datafiles?

Report message to a moderator

Re: problem with size during database creation [message #547784 is a reply to message #547783] Fri, 16 March 2012 10:43 Go to previous messageGo to next message
lg123
Messages: 225
Registered: August 2008
Senior Member
Do you mean to say if i add datafiles and store data worth of 300 GB, then the database size will show as 300 GB?

Report message to a moderator

Re: problem with size during database creation [message #547785 is a reply to message #547784] Fri, 16 March 2012 10:49 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>Do you mean to say if i add datafiles
data is not required

Report message to a moderator

Previous Topic: installation steps for oracle 10g 10.2 on linux 6 using vmware
Next Topic: too many archive log generation
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Feb 23 07:04:14 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.