Re: Export/Import ownership problems...

Carlos Jimenez wrote:
>
> We are exporting some Oracle financial tables from Payables, and we have
> some triggers and indexes on ap tables owned by our customized application
> sqlplus account.
>
> We exported the tables 3 different ways (a. AP user, b. SYSTEM user and c.
> SYSTEM user [again]).
>
> When we imported the tables back to AP.
>
> a. Imported back by the AP account. We got all the tables
> but we lost all the customized triggers and customized indexes.
>
> b. Imported back by the SYSTEM account. We have everything back but all
> was owned by AP. The customized account lost control of the triggers
> and indexes.
>
> c. Imported back by the SYSTEM account with FROMUSER=(AP,SYSTEM,CUSTOM)
> and TOUSER=(AP,SYSTEM,CUSTOM). Same results as in b.
>
> Does anybody have any ideas of how to resolve these kinds of problems.
> I actually open all the export dump files and the dump does not any
> information about the were the triggers or indexes come from, it just
> have the necessary scripts to created but does not care who owns the
> objects.
>
> I tried these test on RDBMS 7.1.6.2 and 7.3.2 with the same results.
>
> We will have bigger problems in the Oracle applications (Financials,
> manufacturing, etc) since starting with apps 10.7 the APPS account will
> own triggers, views, etc from all other 41 applications.

Try Imported by the SYSTEM account with FROMUSER=(AP,SYSTEM,CUSTOM)

   and TOUSER=(AP,AP,AP). Same results as in b. Received on Sat Apr 05 1997 - 00:00:00 CEST