Hello,
I have been tasked with "migrating" data from one Oracle DB to another Oracle DB of same schema.
This DB is used as a multi-tenant seperated by a logical column (e.g. Organisation ID).
I am now being asked to move data from this DB into another DB in a different location - as such I need to extract specific inter dependent data (e.g. 50 tables, but in some way linked via organisation id)
has anyone done this before, if so how and what tools did you use?
Thanks in advance.
"I'm living so far beyond my income that we may almost be said to be living apart
I have been tasked with "migrating" data from one Oracle DB to another Oracle DB of same schema.
This DB is used as a multi-tenant seperated by a logical column (e.g. Organisation ID).
I am now being asked to move data from this DB into another DB in a different location - as such I need to extract specific inter dependent data (e.g. 50 tables, but in some way linked via organisation id)
has anyone done this before, if so how and what tools did you use?
Thanks in advance.
"I'm living so far beyond my income that we may almost be said to be living apart