Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> changing tables to a different schema

changing tables to a different schema

From: JSI FundRaising R&D Group <mjames_at_jsifrs.com>
Date: Fri, 1 Oct 1999 11:22:52 -0400
Message-ID: <fk4J3.2256$L4.191288@typ12.nn.bcandid.com>


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:22:52 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US