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

Thread: Oracle Database Multiple Schema(s) / Multiple Servers

  1. 05-26-2005, 05:23 AM #1
    swapsg
    swapsg is offline Junior Member
    Join Date
    May 2005
    Location
    Mumbai , India
    Posts
    1

    Oracle Database Multiple Schema(s) / Multiple Servers

    Dear Experts

    We are planning to deloy an ERP application for our 4-5 Sister compnaies on the single oracle database server.

    Hardware is not a constraint but the requirement is to keep data separated for each companies.

    I have tried to explain the management , pros and cons for not choosing multiple oracle database server and keeping mutiple schema for each company.

    point i have to is hardware resources will be more per database server, maintainance will be nightmare, etc.

    Can anybody give me more details or some internet links ,on the above said subject to convince my management.

    Thanks

    Swapnil Gadkari
    Reply With Quote Reply With Quote
  2. 05-26-2005, 05:35 AM #2
    davey23uk
    davey23uk is offline Senior Advisor
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    http://asktom.oracle.com/pls/ask/f?p...:2246908001297
    Reply With Quote Reply With Quote
  3. 05-26-2005, 06:06 AM #3
    mganda2005
    mganda2005 is offline Banned
    Join Date
    May 2005
    Posts
    17
    whats ERP again davey? is it similar to SAP financials?
    Reply With Quote Reply With Quote
  4. 05-26-2005, 06:25 AM #4
    jovery's Avatar
    jovery
    jovery is offline Ha Ha
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    Originally posted by mganda2005
    whats ERP again davey? is it similar to SAP financials?
    http://www.webopedia.com/TERM/E/ERP.html
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!
    Reply With Quote Reply With Quote
  5. 05-26-2005, 08:43 AM #5
    marist89's Avatar
    marist89
    marist89 is offline Super-Genius
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    If you're going with something like Oracle Apps, you will have to do multiple instances since all the GL stuff is in the GL schema, AR is in AR, etc...
    Jeff Hunter
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width