developers

    Forum Stats

  • 3,873,880 Users
  • 2,266,627 Discussions
  • 7,911,650 Comments

Discussions

Oracle 19c Transport Tablespace Alternative for SE2

Mika14
Mika14 Member Posts: 160 Bronze Badge
edited Sep 23, 2022 8:02PM in General Database Discussions

We would like to Transport a Tablespace from one database to another (both 19c).

We are using Oracle 19c SE2. Unfortunately, SE2 is not licensed to use Transport Tablespace.

Are there any other alternative ways to copy tablespace from one database into another?

Best Answer

  • asahide
    asahide Expert Technical Engineer Member Posts: 1,496 Gold Trophy
    Answer ✓

    Hi,

    I think regular expdp/impdp is available, but I am guessing that there must be other requirements.

    If you can describe the data capacity, time limit, etc., I'm sure we can come up with some other ideas.

    Regards,

    Mika14

Answers

  • asahide
    asahide Expert Technical Engineer Member Posts: 1,496 Gold Trophy
    Answer ✓

    Hi,

    I think regular expdp/impdp is available, but I am guessing that there must be other requirements.

    If you can describe the data capacity, time limit, etc., I'm sure we can come up with some other ideas.

    Regards,

    Mika14
  • Mika14
    Mika14 Member Posts: 160 Bronze Badge

    Hi asahide,

    Thank you so much for your quick response.

    I was able to accomplish what was needed using expdp/impdp for Schemas.

    Again, thank you for pointing me in the right direction.

developers