| amjad |
Posted: Apr 23, 2008 04:54:27 AM |
Total Post: 23
Joined: Feb, 2008
|
please can any one send me the query for export and import from diffreant tables such as hr_finance ,acc_vaction where emp_NO =1775
i want to export this employees records from diffreant table and imp to other database .
i am using the oracle 9i on windows platform
|
|
|
 Murtuja |
| Posted: Apr 23, 2008 05:35:34 AM |  |
|
Total Post: 814
Joined: Jan, 2006
|
exp parfile='c:\parafile.txt'
parafile.txt will have these lines
FILE="C:\testqry.DMP"
LOG="C:\exp_testqry.log"
TABLES=('SCOTT.EMP')
QUERY="where empno=7654"
INDEXES=N
TRIGGERS=N
CONSTRAINTS=N
GRANTS=N
|
|
|
|
|
| amjad |
| Posted: Apr 23, 2008 06:30:13 AM | |
|
Total Post: 23
Joined: Feb, 2008
|
HR_ACC_VACATION (filtered by emp_kgl_no)
HR_DECISIONS_DT (filtered by emp_kgl_no)
HR_DECISIONS_NFIN_DT (filtered by emp_kgl_no)
where emp-kgl_no=17995
like this they are my tables i had to export it from the server pls tell me the query that how to run from the server as system user
|
|
|
|
|
| GOPU |
| Posted: Apr 23, 2008 07:08:22 AM | |
|
Total Post: 242
Joined: Apr, 2008
|
exp system/passwd file=D:\file\exp.dmp tables=('SCHEMA.HR_ACC_VACATION') query=('where emp-kgl_no=17995')
|
|
|
|
|
| amjad |
| Posted: Apr 24, 2008 04:41:23 AM | |
|
Total Post: 23
Joined: Feb, 2008
|
thanks every much for you support i had take the export sucessfully but when i tried to import all the eleven table data filter by emp_no 17995
it is showing this error
. importing HR2003's objects into HR2003
. . importing table "HR_ACC_VACATION" 13 rows imported
. . importing table "HR_DECISIONS_DT"
IMP-00019: row rejected due to ORACLE error 2291
IMP-00003: ORACLE error 2291 encountered
ORA-02291: integrity constraint (HR2003.HDD_HEM_FK) violated - parent key not found
i had imp with option ignore=y constraints=y but this error is still
please reply me its urgent
|
|
|
|
|
| GOPU |
| Posted: Apr 24, 2008 06:05:26 AM | |
|
Total Post: 242
Joined: Apr, 2008
|
Hi,
you have to give
index=n constraint=n
try
gopu
|
|
|
|
|
| GOPU |
| Posted: Apr 24, 2008 06:08:19 AM | |
|
Total Post: 242
Joined: Apr, 2008
|
Hi friend,
Cause: A foreign key value has no matching primary key value.
Action: Delete the foreign key or add a matching primary key.
otherwise try by giving constraints=n
Regards
Gopu
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
