Hopefully someone out in ORACLE land can comment and
advise on this. I have received a lot of valuable
information from this working group. Thanks for all of
your comments and help (Lisa, Tony, Lucie...). On to the
important issues.
We want to set up a DB system (ORACLE) that may have to be
used by two projects each with different needs. The
computer configuration at this time is:
- VAX 4000/90 running OpenVMS 6.1.
- 3 RZ28's (2 GB each)
- 128 Meg Memory
- Ada, C, Motif, DECmessageQ
- Is it best to have one DB and separate the projects by
tablespaces.
- Have two separate DB's one for each project. If so,
how are the tablespace/datafiles placed on the drives.
An issue that we must consider is the one project will be
transferred to a target system at a later time.