Re: Switching between tablespaces as superuser

From: Thor HW <thor_at_echidna.net>
Date: 1997/07/30
Message-ID: <01bc9d5d$e29e8450$c570248e@thor_hw>#1/1

I don't quite understand your question ... If you are asking how to build things in a different tablespace ... then every creation DDL command allows you to specify which tablespace you'd like the object created in, given that you have quota on that resource. If you want to give SYSTEM a different default tablespace then you can alter the user and define a different default and temporary tablespace. Thor HW

Gary T. Smith <gsmith_at_clientserver.com> wrote in article <33DFD936.776B_at_clientserver.com>...
> How does one switch between tablespaces as superuser (system/manager)?
>
> Thanks in advance.
>
Received on Wed Jul 30 1997 - 00:00:00 CDT