Kinda of a dumb question
From: Goulet, Richard <Richard.Goulet_at_parexel.com>
Date: Thu, 14 Apr 2011 15:45:19 -0400
Message-ID: <6B0D50B70F12BD41B5A67F14F5AA887F0FE64D06_at_us-bos-mx022.na.pxl.int>
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??
Date: Thu, 14 Apr 2011 15:45:19 -0400
Message-ID: <6B0D50B70F12BD41B5A67F14F5AA887F0FE64D06_at_us-bos-mx022.na.pxl.int>
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
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Apr 14 2011 - 14:45:19 CDT