Re: Kinda of a dumb question

A development team should have a set of scripts that are used to create the schema. They need to modify these scripts to accommodate the change from one schema to two. Then your job becomes manageable. If they have misplaced or haven't maintained their scripts, point out that you can move the tables, but for the other objects you aren't a magician (assuming you haven't portrayed yourself as such).

I don't think the important issue is how to help the developers out at the moment on what I assume is a test database, but later when you are going to roll this out in production. The great thing about working from scripts is then you can execute the same scripts in production. If they don't have scripts now, there are several tools like Toad that can generate scripts. Depending on your version of Oracle, there are features for that.

Dennis Williams

On Thu, Apr 14, 2011 at 2:45 PM, Goulet, Richard <Richard.Goulet_at_parexel.com
> wrote:

> 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-l