Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Copying schema from one user to another
Hi,
env is : Oracle 817, Solaris 8
My problem : I use an tierce part application on which I've few
visibility, and my main problem is that this application is using two
instances but need to create tablespaces with the same name in the two
instances.
My client uses norms saying that tablespace names must include
instance name. ie instance DB1 will have TBS DATA_DB1 and IDX_DB1
while instance DB2 will have TBS DATA_DB2 and IDX_DB2.
Because I can't modifiy application I try to turn problem by
1) creating DB as application wants, saying with TBS DATA and IDX for
both instances and on a "pseudo" schema "user1"
2) creating real user "user"
3) creating TBS DATA_DB1, IDX_DB1 on DB1, DATA_DB2 and IDX_DB2 for the
second instance
4) moving objects (and resizing initial segments) to definitive user
"user" and TBS
But I still have problems with :
In fact, I'm not sure to use the good method to handle the problem and I'm afraide to discover others errors in future.
My questions are:
Do you think this method to be the good one? Would you use another
one and which one ?
If you think this method to be good, how would you handle snapshots,
partitioned tables, triggers, procedures ... ?
Do you think to other elements I couldhave forgotten ?
Thanks for your advices
Regards
Frederic PAYANT - junior DBA ;-)
Received on Sun Apr 07 2002 - 15:53:36 CDT