0

Actually on Oracle 10g. We could migrate to 12c if this can help us out.

  • We 2 schemas : A_ADMIN and A2.
  • Main schema is A2 which contains some synonyms pointing to A_ADMIN tables.
  • We'd like to move referenced A_ADMIN objects to A2 schema so only one schema would be needed.
  • There are triggers, packages, indexes, unicity constraints...

What's the best way to proceed, considering we have development and production environment so we'd like to prepare migration script(s) to do so ?

MensSana
  • 521
  • 1
  • 5
  • 16
  • 1
    A tablespace does not have schemas, there is no direct relationship between the two. Schemas may store objects in many tablespaces, tablespaces may have objects from multiple tablespaces. How much data are we talking about? The simplest option (though not the most efficient) would probably be to export and import the data while changing the schema owner. – Justin Cave Mar 11 '14 at 14:41
  • Thank you Justin for this clarification, I'm no DBA at all as you can see... Confusion must come from the fact I noticed a tablespace is a true file (OS filesystem) where my schema seems to be stored in... I already tried this but it seems I have to refine my procedure since there are too many conflicts (unicity constraints as far as I know). I'll try to go further and refine my question... – MensSana Mar 11 '14 at 14:58
  • 1
    @JustinCave - I suspect you meant "...tablespaces may have objects from multiple **schemas**". – Bob Jarvis - Слава Україні Mar 11 '14 at 16:55
  • @BobJarvis - Quite right, yes. – Justin Cave Mar 11 '14 at 17:10

0 Answers0