Re: The example schemas
From: Odd Morten Sveås <odd.morten.sveas_at_accenture.com>
Date: 12 Oct 2002 14:57:24 -0700
Message-ID: <4306a83.0210121357.655dd553_at_posting.google.com>
Date: 12 Oct 2002 14:57:24 -0700
Message-ID: <4306a83.0210121357.655dd553_at_posting.google.com>
"Yong Liu" <fdu9774_at_rogers.com> wrote in message news:<jBKp9.227637$8b1.96329_at_news01.bloor.is.net.cable.rogers.com>...
> Hi,
>
> In Oracle 9i, example schemas such as scott, hr .. are installed at the
> system tablespace at the installation time. I want to transfer them to user
> tablespace. Now I can drop them and recreate them at users table space using
> the installtion scripts. But I am looking for a better alternative. What can
> you do to help?
>
> Thanks
Hi
alter user scott default tablespace user;
Regards
Odd Morten
Received on Sat Oct 12 2002 - 23:57:24 CEST