Establishing Multiple Tablespaces on a Single Oracle Server Last updated Save as PDF Establishing Multiple Tablespaces on a Single Oracle Server Below is a brief summary of the steps required for working with multiple Oracle projects. Establish the tablespace, user, and role. Import the Dmp file. Establish the Oracle roles. Establish synonyms, if you are creating multiple SQL user IDs. Verify that the Archibus projects login with different credentials