Creating tablespaces over a network
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Creating tablespaces over a network

  1. #1
    Join Date
    Dec 2001
    Posts
    337

    Creating tablespaces over a network

    Hi all,

    I have a question:

    Is it possible for one to create a tablespace over a network (i.e a mapped drive on windows)? A situation has arisen where extra space is needed to load more info into the db. There is spare space on another server but i need to know if it is possible techinally to achieve this? Any help will be much appreciated. We are running on a Windows platform.

    Thanks in advance,
    Chucks

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    yes - dont expect it to perform very well though.

    If its windows I believe there are some special options you need to use with networked storage

  3. #3
    Join Date
    Dec 2001
    Posts
    337
    Hi Davey,

    Thanks for that. We dont expect it to perform well however it needs to be done. Do you have any idea what these specail options are?

    Thanks in advance,
    Chucks

  4. #4
    Join Date
    Nov 2006
    Location
    Sofia
    Posts
    630
    In general Oracle does not supports that. It is possible but really needs some specia options AND IS NOT SUPPORTED BY ORACLE.
    Oracle supports only network mapping protocols, which supports write confirmation (i.e. when the server sends a write request, the protocol should return a confirmation that it is done) This is not the case however with windows mapped drives and NFS mapped drives.
    Maybe you should look for some solution usnig the iSCSI protocol
    Search metalink and I belive you'll find details about that

    Regards
    Boris

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