Re: changing tables to a different schema

From: Dean <rilecode_at_chemist.com>
Date: Fri, 01 Oct 1999 08:53:26 -0700
Message-ID: <37F4D8F6.7F34969F@chemist.com>

I believe you can use the script on the Oriole site called rename_user.ksh . They do claim that you would not want to do this on a production machine.

url: http://www.oriolecorp.com/frameindexXX.html

Rick

JSI FundRaising R&D Group wrote:

> Without going into the why, our clients need to move all of our tables from
> the SYSTEM schema to a new power user schema. I know that we can use
> export/import to do this but would like an easier solution if one is
> available. Is there a change ownership function? or does anyone have other
> solutions to accomplish this?
>
> Export/Import would require a little more user decisions then some of our
> users could handle....
Received on Fri Oct 01 1999 - 10:53:26 CDT