Re: Creating a tablespace alias?

Terry is correct. If you want different tablespaces used, you have to create 2 users: SHAREDSPACE and MYSPACE. Create each user to use a different tablespace. You will then have to issue the appropriate grants.

Even better: Just create a test table in MYSPACE

Best:
Create a test instance that is exactly like your future or current production instance. No changes needed, and everybody can play nice without affecting the other.

Hope this helps. This is very high level obviously. Received on Tue Oct 22 2002 - 18:16:10 CDT