Re: Removing change manager tables
From: IANAL_VISTA <IANAL_Vista_at_hotmail.com>
Date: Wed, 29 Jun 2005 13:36:33 GMT
Message-ID: <Xns9684433BDE0F3SunnySD_at_68.6.19.6>
Date: Wed, 29 Jun 2005 13:36:33 GMT
Message-ID: <Xns9684433BDE0F3SunnySD_at_68.6.19.6>
"attiq76" <attiq76_at_yahoo.com> wrote in news:1120039702.398456.278120_at_f14g2000cwb.googlegroups.com:
> Hi All,
>
> I wanted to to use Oracle Change Manager & by mistake I used the same
> schema & oracle username for change manager where all the original data
> tables are.
>
> Now I see a big list of oracle change manager tables (name starting
> with) SMP_..., EPC_...VDK_.. and the original data tables are in the
> same list.
>
> Is there any way to remove all these tables & create them in a seperate
> schema?
>
Yes, by using SQL
Received on Wed Jun 29 2005 - 15:36:33 CEST