Home » RDBMS Server » Server Administration » Moving data's with out down the application
Moving data's with out down the application [message #164001] Tue, 21 March 2006 04:17 Go to next message
gjayasekar
Messages: 45
Registered: October 2005
Member
Hi,

We are using oracle 9.2.0 with weblogic application

every month end we are stopping all the weblogic instance and

create a new table as select * from old_table;

then move the old table with old data's to development after

that we are starting all weblogic instance and connect to the

application for this work we are taking down time 2 hrs - in

production environment

please provide a solution to do this without downtime

thanks
jai

Report message to a moderator

Re: Moving data's with out down the application [message #164008 is a reply to message #164001] Tue, 21 March 2006 04:56 Go to previous message
orausern
Messages: 826
Registered: December 2005
Senior Member
What is the purpose of stopping the weblogic application? is that to ensure that no one else modifies the table? If that is the case, then you may lock the table in exclusive mode and create the new table..

Report message to a moderator

Previous Topic: regarding passwordfile authentication
Next Topic: Problems compiling a package / package body
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Feb 18 19:18:58 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.