Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Copying schema from one user to another

Copying schema from one user to another

From: Frederic Payant <fpayant_at_club-internet.fr>
Date: Sun, 07 Apr 2002 22:53:36 +0200
Message-ID: <3pa1bu0cdtqvob4ofrne1i0ndtbucer7ji@4ax.com>


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

  1. export full
  2. creating table (as select *) with good storage clauses by user "user"
  3. creating indexes (from an imp indexfile=xxx) parsed by awk for having good storage clauses
  4. imp of othe objects of user "user1" to user "user"

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US