| discover EUL copy [message #89173] |
Fri, 31 October 2003 04:42  |
cinzia
Messages: 1
Registered: October 2003
|
Junior Member |
|
|
Hi,
my problem is about copying EUL objects into another but referring to data and table of a different Oracle user. Let me explain.
UserDB1 is a Oracle user who owns objects in DB (tables, views, syn, materialized views, procedures,...)
EULOwn1 is an Oracle user who owns EUL1; all objects in EUL1 (Business Area, Folder, Worksheet,..) refer to UserDB1 data tables
UserDB2 is an Oracle user owning the same objcts as UserDB1, only data are different (let me say, tables holds only historical data)
Now I would like to copy EUL1 into EUL2 (owned by EULOwn2) in such a way that EUL2 references data in UserDB2 schema
Is it possible?
Thank you
Cinzia
|
|
|
|
| Re: discover EUL copy [message #89174 is a reply to message #89173] |
Fri, 31 October 2003 06:33  |
Geoffrey
Messages: 32
Registered: February 2002
|
Member |
|
|
If user EULOwn2 does not have any EULs this might work (I haven't tested it but it should work):
copy the EULs from user EULOwn1 to user EULOwn2.
run the following SQL statement :
update
EULOwn2.EUL_OBJS
set
obj_ext_OWNER = 'EUL2'
where
obj_ext_OWNER = 'EUL1';
commit;
regards,
Geoffrey
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
