Transportable Tablespace in Oracle - TTS - Database Migration Using TTS Simple Steps

preview_player
Показать описание
We have 2 database in 2 different pc

S1=
---
ip address : 192.168.0.181

SID : catdb
Now create tablespace (sales) , create a user with default tablespace sales

our target transport this tablespace (sales) to another pc (T1)

sales tablespace=datafile+metada(datafile copy to 2nd pc by scp/ftp....and metadat by expdp)

T1=
---
---
ip address : 192.168.0.182

SID : prod

now use impdp to insert metadata to local db datadictioary and relation between data and metadata)

check my video and steps::::

#TTS #TransportableTablespace #Migration

Please do follow me and support me on,

Skype: malluramadurg

Regards,
Mallikarjun Ramadurg
Mobile: +91 9880616848
WhatsApp: +91 9880616848
Skype: malluramadurg
  1. Vismo Technologies
  2. TTS
  3. Migration
  4. Database Migration
  5. Transportable Tablespace
Рекомендации по теме
Transportable Tablespace in 0:20:28

Transportable Tablespace in Oracle - TTS - Database Migration Using TTS Simple Steps

Ways of testing 0:03:16

Ways of testing your migration of Oracle Database using transportable tablespaces

Migrate Oracle Database 0:02:47

Migrate Oracle Database using transportable tablespaces

Oracle Database Migration 0:22:11

Oracle Database Migration Methods - Goldengate, Transportable Tablespace, RMAN, Export - Import &...

Transportable Tablespace and 0:08:44

Transportable Tablespace and Full Transportable Export/Import

Cross Platform Transportable 0:17:18

Cross Platform Transportable Tablespaces (XTTS) with Incr Backup - Database Migration AIX to Linux

Transportable Tablespaces - 0:06:09

Transportable Tablespaces - the basics

Migrate to Amazon 0:35:00

Migrate to Amazon RDS for Oracle using Transportable Tablespaces | AWS Events

Masterclass Oracle Database 1:24:23

Masterclass Oracle Database do Zero - Aula 3 - Aula prática Oracle Database 19c

Transportable tablespaces and 0:01:23

Transportable tablespaces and Data Guard

From Transportable Tablespaces 0:09:27

From Transportable Tablespaces to Pluggable Databases

Migration to Multitenant 0:03:30

Migration to Multitenant using Transportable Tablespaces

Understand Transportable Tablespaces 0:05:01

Understand Transportable Tablespaces and Cross-endian Migration

Migrate your data 0:15:49

Migrate your data to Amazon RDS for Oracle using Transportable Tablespaces - AWS Databases in 15

Fallback options when 0:01:18

Fallback options when you migrate Oracle Database using transportable tablespaces

Migrate 230 TB 0:08:37

Migrate 230 TB database using cross-platform transportable tablespaces

Transporting tablespace to 0:21:59

Transporting tablespace to different platform by Using RMAN

Prerequisites for migrating 0:06:59

Prerequisites for migrating Oracle Database using transportable tablespaces

Transportable tablespaces - 0:05:54

Transportable tablespaces - a checklist

Transportable Tablespaces with 0:05:04

Transportable Tablespaces with incremental backup

Lecture 13 Transportable 0:05:46

Lecture 13 Transportable Database In Oracle

Oracle Transportable Tablespace: 0:45:52

Oracle Transportable Tablespace: Movimentando tablespaces entre Sistemas Operacionais Iguais

Full Transportable Export 0:07:38

Full Transportable Export Import (FTEX) for Cross-endian Migration

Demo: Full transportable 0:07:42

Demo: Full transportable export/import and incremental backup

Комментарии
Автор

This was very good tutorial. Thank you so much!

ranXXX
Автор

This is really great.. so in case of ASM storage we have to copy all the datafile from source nd paste in on target server.nd also should mention all the datafiles in transportable_datafile clause will importing .. correct.. when this kind of method is recommended .. for what db size .

RameshKumar-dyez
Автор

Thanks for sharing vedio it help for us.
& Please make vedio for expdp & impdp related

ajayyadav-nlbw
Автор

i have 2 questions :


1.what is difference in normal export/import and transortable tablespace bcz same export/import of a tablespace we can do with exp/imp ?





2.tablespace you are taking export remains unavilable for write operations during this ...?


plz reply

rehantayyab
Автор

Very good presentation. Can the Source DB be Oracle 11.2.0.4 on Linux (64-Bit) and Target be Oracle 19c on Linux (64-Bit)?

thiruardura
Автор

How to transfer datafiles from source asm to target asm?

БарзуПарпишоев
Автор

Would you please do a video on Zero downtime patching in 19.3 rac database?

ma
Автор

@malliko34 why should I use transportable tablespaces if I could do a normal export and create the necessary objects like the user, profile, tbs, roles, etc then import? What's the benefits of using transportable tablespaces and the normal approach I talked about above?

GilbertMyers
Автор

I have my database 11.2.0.1 I want o upgrade it to 11.2.0.4 without downtime can please guide me on this one

mughees