Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Export/Import ownership problems...
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.
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.
Best regards, Carlos R. Jimenez. E*mail: Jimenez_carlos_at_tandem.comReceived on Mon Mar 31 1997 - 00:00:00 CST