Re: Move data from production schema to development schema which has some modifications
From: Mark D Powell <Mark.Powell2_at_hp.com>
Date: Tue, 19 Jan 2010 07:03:49 -0800 (PST)
Message-ID: <b9cef7a1-7efa-44d9-a4f5-20f00b7f5b9b_at_36g2000yqu.googlegroups.com>
On Jan 19, 9:37 am, gazzag <gar..._at_jamms.org> wrote:
> On 19 Jan, 12:49, Naga <nagaraj.mam..._at_gmail.com> wrote:
>
>
>
>
>
> > Hi Tom/Group,
>
> > Hi All,
>
> > I am new to DB related development, I am currently asked to come up
> > with a solution to write a script or use a tool to map tables between
> > two schemas and copy data from one DB to another
> > A simple scenario would be, we have our production DB with the current
> > schema, we have a change in structure of development DB or just change
> > names of some columns in some tables.
> > the requirement is to have a script or a tool which can backup the
> > production data and copy them to the new structure of development DB
>
> > Is there any way i can export data from production system, and import
> > them in the modified schema(which has some column names changed or
> > tables added with null value).
>
> > can anyone help me in this regard as I am totally blank on how to
> > proceed with this.
>
> > Thanks in Advance,
>
> > Nagaraj Mamedi
>
> > Eagerly awaiting for the solution !!!!!!!!!!!!
>
> What version of Oracle? In any case, you have inadvertently answered
> your own question. Oracle provides both a database import and export
> tool - DataPump. Look up the documentation for "impdp" and
> "expdp" (or "imp" and "exp" depending on your version.
>
> http://download.oracle.com/docs/cd/B19306_01/server.102/b14215/dp_ove...
>
> Once you have an idea of what you want to achieve, there are plenty of
> people here who will answer any further questions.
>
> HTH
>
> -g- Hide quoted text -
>
> - Show quoted text -
Date: Tue, 19 Jan 2010 07:03:49 -0800 (PST)
Message-ID: <b9cef7a1-7efa-44d9-a4f5-20f00b7f5b9b_at_36g2000yqu.googlegroups.com>
On Jan 19, 9:37 am, gazzag <gar..._at_jamms.org> wrote:
> On 19 Jan, 12:49, Naga <nagaraj.mam..._at_gmail.com> wrote:
>
>
>
>
>
> > Hi Tom/Group,
>
> > Hi All,
>
> > I am new to DB related development, I am currently asked to come up
> > with a solution to write a script or use a tool to map tables between
> > two schemas and copy data from one DB to another
> > A simple scenario would be, we have our production DB with the current
> > schema, we have a change in structure of development DB or just change
> > names of some columns in some tables.
> > the requirement is to have a script or a tool which can backup the
> > production data and copy them to the new structure of development DB
>
> > Is there any way i can export data from production system, and import
> > them in the modified schema(which has some column names changed or
> > tables added with null value).
>
> > can anyone help me in this regard as I am totally blank on how to
> > proceed with this.
>
> > Thanks in Advance,
>
> > Nagaraj Mamedi
>
> > Eagerly awaiting for the solution !!!!!!!!!!!!
>
> What version of Oracle? In any case, you have inadvertently answered
> your own question. Oracle provides both a database import and export
> tool - DataPump. Look up the documentation for "impdp" and
> "expdp" (or "imp" and "exp" depending on your version.
>
> http://download.oracle.com/docs/cd/B19306_01/server.102/b14215/dp_ove...
>
> Once you have an idea of what you want to achieve, there are plenty of
> people here who will answer any further questions.
>
> HTH
>
> -g- Hide quoted text -
>
> - Show quoted text -
Oracle also provideds the sqlldr utility which is described in the same manual gazzag referenced, to load delimited or fixed position data into database tables from flat files. The Oracle External table feature is basically a means to execute sqlldr from within the database.
If you need to move data into Oracle from a non-Oracle source you may find sqlldr handy.
HTH -- Mark D Powell -- Received on Tue Jan 19 2010 - 09:03:49 CST