Announcement

Collapse
No announcement yet.

Synapse Tablespace Oracle

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Synapse Tablespace Oracle

    Hi,

    First off, I am no Mirth Admin, background is Oracle DBA.

    I want to move all the objects in the current oracle database tablespace into a new one within the same database, the schema owner/mirth user will remain the same. I was planning to use offline table move and then rebuild indexes:

    Code:
    alter table <table_name> move tablespace <new_tablespace_name>;
    Is it as straight forward as this? I ask because someone has suggested something very different, that includes exporting the channels, creating new schema/mirth users, importing the channels...etc.etc.

    Appreciate guidance on this please, if someone can point me to a knowledge article or something similar that would be helpful.

    Thanks.
Working...
X