DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: problem with size during database creation..

  1. #1
    Join Date
    Sep 2007
    Posts
    19

    problem with size during database creation..

    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?

  2. #2
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,492

    Cool

    Quote Originally Posted by lg123 View Post
    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?
    1) Run dbca manually, select the "custom" template and change what you want -- or --

    2) Using Enterprise Manager dbconsole add/modify the sizes of the datafiles

    3) manually issue the commands for #2 using SQL*Plus

    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width