| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: No record in import help me please :..<(
Hi guys,
Thank You
Durinda.Jones
Don.Jerman
Dave Weber
Gillies Garry
Raghu Kota
Ruth Gramolini
Mohan, Ross
And to all readers..
What I am doing now is to try write my own backup script and test it in my
stand alone Sun Ultra 10
with Solaris 2.7 and Oracle 8.1.6
Thank you guys, for giving me solution, "SHOW = N" and "DESTROY=N"
it is work 7 records was imported into the table.
Now I try to import my previous myemp.dmp after teddy "drop table emp" my import parameters as at point 8.
I export with this params.dat :
exp sun/solaris parfile=/export/home/dba/myemp.dmp
I've got messsges :
. . exporting table EMP 7 rows exported
5. I check the file is exist and with
-rw-rw-rw 1 dbadmin 3072 Mar (time) myemp.dmp
6. I chmod a+x myemp.dmp
7. teddy delete emp table :
delete emp
7 rows deleted
8. when as sun I try to import :
inside my imp_params.dat :
FILE=/export/home/dba/myemp.dmp
FROMUSER=TEDDY
TOUSER=TEDDY
TABLES=(emp)
IGNORE=Y -> because the table is not exists ??
GRANTS=Y
ROWS=Y
COMMIT=Y
I import
imp sun/solaris parfile=imp_params.dat
9. the messeges that I got :
. import TEDDY's Object
. . importing table "EMP"
IMP-00019: row rejected due to ORACLE error 1
IMP-00003: ORACLE error 1 encountered
ORA-00001: unique constraint (TEDDY.EMP_PK) violated
Column 1 11
Column 2 Don
Column 3 McIntyre
Column 4 03-Jun-1972:00:00:00
IMP-00019: row rejected due to ORACLE error 1
IMP-00003: ORACLE error 1 encountered
ORA-00001: unique constraint (TEDDY.EMP_PK) violated
Column 1 12
Column 2 Micheal
Column 3 Jackson
Column 4 25-Jun-1988:00:00:00
....
....
Import terminated successfully with warnings.
10. When teddy select * from emp;
ERROR at line 1
ORA-00942: table or view does not exist
Can someone help me please... please ??? :<(
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: sinardyxing_at_bcsis.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: sinardyxing_at_bcsis.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Mar 06 2001 - 21:53:48 CST
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
 |
 |