Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Copying schema from one user to another
Frederic Payant <fpayant_at_club-internet.fr> :
No answer at all :-(((
Is my question :
-> too tricky -> unclear -> stupid
Thanks for your help
>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
> a) export full
> b) creating table (as select *) with good storage clauses by user
>"user"
> c) creating indexes (from an imp indexfile=xxx) parsed by awk for
>having good storage clauses
> d) imp of othe objects of user "user1" to user "user"
>
>But I still have problems with :
> - snapshots which are referenced as "user1"."xxxxxx" and make
>errors.
> - jobs which are owned by "user1" and not imported to "user"
>(these jobs are refresh snapshots jobs)
> - procedures, triggers and views which are not recompiled and that
>I must recompile "by hand"
>
>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
>
Amicalement
Frédéric PAYANT
Received on Fri Apr 12 2002 - 14:51:27 CDT