RE: Kinda of a dumb question
- From: D'Hooge Freek <Freek.DHooge@xxxxxxxxx>
- To: "Richard.Goulet@xxxxxxxxxxx" <Richard.Goulet@xxxxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 14 Apr 2011 22:07:48 +0200
Using remap_schema you can import data from one schema into another (replaces
the fromuser / touser parameters in the old imp) and datapump has the
network_link parameter which enables it to transfer data over a db link.
Never tried it, but should probably work.
If not, you will need to export it first to the filesystem.
Regards,
Freek D'Hooge
Uptime
Oracle Database Administrator
email: freek.dhooge@xxxxxxxxx
tel +32(0)3 451 23 82
http://www.uptime.be
disclaimer: www.uptime.be/disclaimer
---
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Goulet, Richard
Sent: donderdag 14 april 2011 21:45
To: oracle-l@xxxxxxxxxxxxx
Subject: Kinda of a dumb question
I've a developer that has asked me to split a schema into two parts as the
development team wants to "reorganize" the application. Well, creating a new
user is rather easy & moving data from one user to another isn't usually much
of a problem, especially when they give you a table list. But these tables
have constraints, foreign keys, permissions and all of the other "stuff" that
comes from an already deployed application. Now normally I'd just run export
and import to move the stuff, but I'm wondering, can you use data pump over a
loop back db link to do the same thing??? Has anyone tried it??
Dick Goulet
Senior Oracle DBA/NA Team Leader
--
//www.freelists.org/webpage/oracle-l
Other related posts:
