DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 17 of 17

Thread: datafile > 2gb

  1. #11
    Join Date
    Oct 2002
    Posts
    391

    Smile

    just added 1 30gb datafile and a 10gb index....

  2. #12
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Keep digging yourself deeper...
    Jeff Hunter

  3. #13
    Join Date
    Oct 2002
    Posts
    391
    i was instrcuted by my seniors to do so....

    anyway, if have small datafiles, then the value for max_filesize has to be really huge for huge databases....

  4. #14
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Originally posted by yls177
    i was instrcuted by my seniors to do so....
    "I was only obeying orders", eh?
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  5. #15
    Join Date
    Sep 2003
    Location
    over the hill and through the woods
    Posts
    995
    Originally posted by yls177
    anyway, if have small datafiles, then the value for max_filesize has to be really huge for huge databases....
    So, is there a problem with that? It's just a parameter setting that can be increased. Only thing is the DB has to be bounced if you're not on 9i
    Oracle it's not just a database it's a lifestyle!
    --------------
    BTW....You need to get a girlfriend who's last name isn't .jpg

  6. #16
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Originally posted by yls177
    i was instrcuted by my seniors to do so....

    You have no authority to make the change yet you ask the question?
    Jeff Hunter

  7. #17
    Join Date
    Oct 2002
    Posts
    391
    i have to make the change... and wanted to add soemthing small but was (according to your terms), "told", "command", "instructed" to add bigger datafiles..

    earlier on
    dig yourself deeper
    , u meant that its not good to add such huge datafiles?

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