Database Utilities (MOSC)

MOSC Banner

Transportable Encrypted Table Space from One DB to Another in the same machine

edited Oct 12, 2019 5:02AM in Database Utilities (MOSC) 2 commentsAnswered

Hi,

We are having 4 different databases in the same Exadata server. We prepare some data in one DB and move it over to another DB for a different set of processing

Currently we are using Data Pump which does the job in few Hours

We are thinking of using Transportable Tablespace to reduce the time for this movement

We are able to do the following

1. Change the tablespace to "Read Only" in Source

2. Export the Dump using expdp

3. Copy the file between 2 different filegroup in the ASM

Since we are in the same machine we dont realy need a convert operation

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center