Re: copy data

From: <frank.van.bortel_at_gmail.com>
Date: 15 Mar 2006 05:32:46 -0800
Message-ID: <1142429566.882594.263500@i39g2000cwa.googlegroups.com>

No!

import and export are external utilities, not SQL options... You would open a command line interface (CLI) and type: exp user/password_at_db1 tables=stock file=..... compress=n

Then, after creating a copy of stock on db2, you can truncate stock in db2.
You would then, using the same cli:
imp user2/another_password_at_db2 file=... ignore=y

Time to get familiar with the documentation, for imp.exe and exp.exe, look at:
http://www.oracle.com/pls/tahiti/tahiti.to_pdf?partno=a76955&remark=docindex Received on Wed Mar 15 2006 - 07:32:46 CST