tool for copying all data from one schema into another

[Christophe Marcel]

Hi,

This utility works a little bit like the imp/exp utility, except that it
- has a nice interface
- doesn't require multiple steps
- doesn't create a large intermediate file
- has no problems with changes in schema names (e.g. copying from schema
'dev' to schema 'sept_04')
- can handle differences between the schemas (e.g. if you had added a column
to a table in your dev schema, and forgotten to replicate it in your build
scripts for your production database).

The performance is good (it uses bulk loads, and disables constraints before
copying).

The intended usage is for cases where you have a ~read-only production
database (used for data mining), with updates being created at regular
intervals (e.g. once a week, once a month). Once you have finished your
work on your currently updated database, you copy it over to a new (blank)
schema on the production server. Once the copy is finished and things look
good, you re-direct your applications to the new schema and retire the
previous production database.

You can download it at:
http://cmarcel.home.mindspring.com/Programming/CopySchema/CopySchema.htm

Best regards,

Christophe Marcel
http://cmarcel.net

[Hans Forbrich]

please, Please, PLEASE keep in mind that this community prefers such
announcements be made in comp.database.oracle.marketplace

If you want your target community to be happy, respect it's wishes ...

[Bricklen]

Hans Forbrich wrote: please, Please, PLEASE keep in mind that this community prefers such announcements be made in comp.database.oracle.marketplace If you want your target community to be happy, respect it's wishes ...
Hans, please quit spamming this newsgroup....


;)

[Hans Forbrich]

Bricklen wrote:
Hans Forbrich wrote: please, Please, PLEASE keep in mind that this community prefers such announcements be made in comp.database.oracle.marketplace If you want your target community to be happy, respect it's wishes ... Hans, please quit spamming this newsgroup.... ;)

You telling me you want these annoucements?

[Bricklen]

Hans Forbrich wrote: Bricklen wrote:Hans Forbrich wrote:please, Please, PLEASE keep in mind that this community prefers suchannouncements be made in comp.database.oracle.marketplaceIf you want your target community to be happy, respect it's wishes ...Hans, please quit spamming this newsgroup....;) You telling me you want these annoucements?
ummmm..no. I was kidding actually. I was also referring to the fact that
you posted the (almost) same message twice in the same group withing
seconds of each other.

No offense intended.

[Hans Forbrich]

Bricklen wrote:
Hans Forbrich wrote: Bricklen wrote:Hans, please quit spamming this newsgroup....;) You telling me you want these annoucements? ummmm..no. I was kidding actually. I was also referring to the fact that you posted the (almost) same message twice in the same group withing seconds of each other.

Benefits of copy & paste - available in modern operating systems like Linux
<g>
No offense intended.

None taken ... with the heat this topic generates, I just needed to make
sure.

/Hans

[Christophe Marcel]

Hello,

I'm terribly sorry for posting to the wrong newsgroup. I will be more
careful in the future.

Sincerely,

Christophe


"Hans Forbrich" <news.hans@telus.net> wrote in message
news:Bxk7d.7534$223.3591@edtnps89... Bricklen wrote: Hans Forbrich wrote: Bricklen wrote:Hans, please quit spamming this newsgroup....>;) You telling me you want these annoucements? ummmm..no. I was kidding actually. I was also referring to the fact that you posted the (almost) same message twice in the same group withing seconds of each other. Benefits of copy & paste - available in modern operating systems like Linux <g> No offense intended. None taken ... with the heat this topic generates, I just needed to make sure. /Hans

[Daniel Morgan]

Christophe Marcel wrote:
Hi, This utility works a little bit like the imp/exp utility, except that it - has a nice interface - doesn't require multiple steps - doesn't create a large intermediate file - has no problems with changes in schema names (e.g. copying from schema 'dev' to schema 'sept_04') - can handle differences between the schemas (e.g. if you had added a column to a table in your dev schema, and forgotten to replicate it in your build scripts for your production database). The performance is good (it uses bulk loads, and disables constraints before copying). The intended usage is for cases where you have a ~read-only production database (used for data mining), with updates being created at regular intervals (e.g. once a week, once a month). Once you have finished your work on your currently updated database, you copy it over to a new (blank) schema on the production server. Once the copy is finished and things look good, you re-direct your applications to the new schema and retire the previous production database. You can download it at: http://cmarcel.home.mindspring.com/Programming/CopySchema/CopySchema.htm Best regards, Christophe Marcel http://cmarcel.net

Is there some mental process that compels people such as yourself to
not check out the rules for a usenet group and not read the FAQ before
posting?

Please apology for spamming us and repost at c.d.o.marketplace if you
don't want a reception that is as warm as liquid hydrogen and
substantially more flammable.

Thank you.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace 'x' with 'u' to respond)

[Hans Forbrich]

Daniel Morgan wrote:

Please apology for spamming us and repost at c.d.o.marketplace if you don't want a reception that is as warm as liquid hydrogen and substantially more flammable. Thank you.

He did apologize! And then posted apropriately in cdo.marketplace ...

/Hans

[Daniel Morgan]

Hans Forbrich wrote: Daniel Morgan wrote:Please apology for spamming us and repost at c.d.o.marketplace if youdon't want a reception that is as warm as liquid hydrogen andsubstantially more flammable.Thank you. He did apologize! And then posted apropriately in cdo.marketplace ... /Hans

So I see this morning. My ISP didn't have that post when I was
responding. The apology is noted and appreciated and I have taken
the effort to visit his web site in light of his doing so.

--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace 'x' with 'u' to respond)

[Hans Forbrich]

Daniel Morgan wrote:
Hans Forbrich wrote: Daniel Morgan wrote:Please apology for spamming us and repost at c.d.o.marketplace if youdon't want a reception that is as warm as liquid hydrogen andsubstantially more flammable.Thank you. He did apologize! And then posted apropriately in cdo.marketplace ... /Hans So I see this morning. My ISP didn't have that post when I was responding. The apology is noted and appreciated and I have taken the effort to visit his web site in light of his doing so.

I thought it might be a 'timing' situation, so I jumped on it - in part to
let Christophe know 'not to worry'.

/Hans