Home » RDBMS Server » Server Utilities » Moving entire DB (oracle 12c Windows 2012)
Moving entire DB [message #669281] Thu, 12 April 2018 01:45 Go to next message
muthukrish104
Messages: 71
Registered: November 2017
Member
Hi,

Can you tell me the way to merge a entire DB to another DB.

Both the version\os is same.

The size of the DB is 1.5TB.

Instead of export/import every users. Is there any way to export and import the entire DB.

But with the different Name of the USER.
(The Tablespace name is different between two DBs).

Regards.
M.krish
Re: Moving entire DB [message #669284 is a reply to message #669281] Thu, 12 April 2018 04:01 Go to previous messageGo to next message
cookiemonster
Messages: 13747
Registered: September 2008
Location: Rainy Manchester
Senior Member
Datapump lets you put stuff in different schema names.
Re: Moving entire DB [message #669285 is a reply to message #669284] Thu, 12 April 2018 05:16 Go to previous messageGo to next message
muthukrish104
Messages: 71
Registered: November 2017
Member
Hi,

Thanks for the help.

DP is the normal one.

I thought any feature like TRANSPORTABLE TABLESPACE?

Thanks and regards
M.Krish
Re: Moving entire DB [message #669286 is a reply to message #669281] Thu, 12 April 2018 06:42 Go to previous message
EdStevens
Messages: 1148
Registered: September 2013
Senior Member
You need to clarify your requirement. It sounds as if you have USER_A in database DB_A and want to move (or copy?) that entire schema to database DB_B, and rename the schema in the process. Is that correct?

Your comments about tablespaces seems a bit mis-guided. There is no inherent one-to-one relationship between schemas and tablespaces. A schema may have objects in multiple tablespaces, and a given tablespace may have objects from multiple schemas.

What is your desired end-state regarding the two databases?
Previous Topic: Issue with SQL LOADER Control file [merged two by jd]
Next Topic: Sql Loader - oracle
Goto Forum:
  


Current Time: Fri Dec 06 10:11:51 CST 2019