change multifile-TS to bigfile-TS
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: change multifile-TS to bigfile-TS

  1. #1
    Join Date
    Jan 2007
    Location
    Berlin, Germany
    Posts
    4

    change multifile-TS to bigfile-TS

    Hi,

    is it possible to change a multifile-TS (20 files a 2 GB) to a single-file TS ('bigfile') WITHOUT EXPORT/IMPORT in Oracle10 or Oracle9?

    Any ideas?

    Thanks!

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    alter table move tablespace xxxx and then rebuild the indexes

  3. #3
    Join Date
    Feb 2007
    Posts
    212
    Hi, is there any advantage/disadvantage between the two TS types?
    smaller multifile TS seem handy and manageable to copy/backup

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    Quote Originally Posted by jennifer2007
    Hi, is there any advantage/disadvantage between the two TS types?
    smaller multifile TS seem handy and manageable to copy/backup
    do you even understand what a bigfile tablespace is?

  5. #5
    Join Date
    Feb 2007
    Posts
    212
    yes dear...its i think a 1-file TS so if u got 1 big TS for the entire db
    like 1 Tb is scary to backup to other media than a 100X10Gb smallfiles
    which u can do paraller copy
    Last edited by jennifer2007; 03-31-2007 at 02:39 AM.

  6. #6
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    so you dont understand then

  7. #7
    Join Date
    Nov 2004
    Location
    Mumbai, India
    Posts
    452
    Bigfile tablespaces reduce sga usage by an average 475 bytes per file.
    With Bigfile tablespaces manageability becomes easier...No need to extend any datafiles to increase space...just add disk
    But bigfile tablespaces should be used only in conjuction with a logical volume manager because of io load balancing issues
    There are three kinds of lies: Lies, damned lies, and benchmarks...

    Unix is user friendly. It's just very particular about who it's friends are.

    Oracle DBA

  8. #8
    Join Date
    Nov 2006
    Location
    Sofia
    Posts
    630
    Good point Simply_DBA. Jenny is right a file 1T in size, it's scary. So, you use it only with LVM or storage array or ASM, where you do not have a control of where your files are anyway

  9. #9
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    ...all roads lead to ASM anyway
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

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