web stats
Synapse Tablespace Oracle - Mirth Community

Go Back   Mirth Community > Mirth Connect > Support

Reply
 
Thread Tools Display Modes
  #1  
Old 07-02-2019, 07:50 AM
tso617 tso617 is offline
What's HL7?
 
Join Date: Nov 2018
Posts: 1
tso617 is on a distinguished road
Default 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.
Reply With Quote
Reply

Tags
mirth, move, oracle, synapse, tablespace

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -8. The time now is 10:11 AM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2019, vBulletin Solutions, Inc.
Mirth Corporation