OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » Moving entire DB (oracle 12c Windows 2012)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Moving entire DB [message #669281]

Thu, 12 April 2018 01:45

muthukrish104
Messages: 82
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

Report message to a moderator

Re: Moving entire DB [message #669284 is a reply to message #669281]

Thu, 12 April 2018 04:01

cookiemonster
Messages: 13972
Registered: September 2008
Location: Rainy Manchester

Senior Member

Datapump lets you put stuff in different schema names.

Report message to a moderator

Re: Moving entire DB [message #669285 is a reply to message #669284]

Thu, 12 April 2018 05:16

muthukrish104
Messages: 82
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

Report message to a moderator

Re: Moving entire DB [message #669286 is a reply to message #669281]

Thu, 12 April 2018 06:42

EdStevens
Messages: 1377
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?

Report message to a moderator

Previous Topic:	Issue with SQL LOADER Control file [merged two by jd]
Next Topic:	Sql Loader - oracle

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 18 12:34:02 CDT 2025