Re: Replacing Data...

[email protected] Fri, 21 Mar 2003 10:43:05 -0500
Newsgroups	gmane.comp.db.oracle.devel
Message-ID	<LYRIS-1796914-922115-2003.03.21-15.40.27--gcdod-oracle#[email protected]>
why don't you use the import export utilities that Oracle provide - They
are quick and easy.



                                                                                                           
                      LVadlamudi@prcnet                                                                    
                      .com                     To:       "Oracle" <[email protected]>                    
                                               cc:                                                         
                      03/21/2003 10:21         Subject:  [oracle] Replacing Data...                        
                      AM                                                                                   
                      Please respond to                                                                    
                      "Oracle"                                                                             
                                                                                                           
                                                                                                           




Hi,

I want to Replace data from one database DB1 to another DB1 without
dropping
the table...

Iam using the script as below..

copy from DB1 to DB2 replace TABLE1 using select * from TABLE1.

But it's not Replacing the data...

Can anyone help me out in this issue?

Thanks in Advance
lakshmi

---
Change your mail options at http://p2p.wrox.com/manager.asp or
to unsubscribe send a blank email to %%email.unsub%%.






---
Change your mail options at http://p2p.wrox.com/manager.asp or 
to unsubscribe send a blank email to [email protected].