Hello Murat
Export has a parameter Query that allow you to specify selection criteria
for exporting a subset of records from the table. Import also has parameter
Ignore=y and then the import ignore the error of the create table statement
and append the imported records into an existing table.
So
There are issues here. Will the table being copied to have the same
constraints in place as those tables from which the data is being extracted?
If so, resolves those, and get these reference tables in place first.
Then simply use a database link to 'pull' the data from your source tables,
eg
- create database link ...
- insert into ... select from ...
- delete from ...
- commit
- drop database link ...
Cheers
Connor
--- MURAT BALKAS [EMAIL PROTECTED] wrote:
Hi,
what's the best method to move some rows of
some tables of a user
from one database to another database on
Murat - The best method depends on several circumstances such as how much
data is involved. The simplest method if you have two Oracle instances is
export/import. Is the username the same on both instances? Are there
differences between the instances such as NLS character sets? Are both
instances
by: Subject: RE: move some records of some
tables
[EMAIL PROTECTED
DWILLIAMS@LIFETOTo: Multiple recipients
of list ORACLE-L [EMAIL PROTECTED]
UCH.COM cc:
Sent by: Subject: RE: move some
records of some tables