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. 1. In my Oracle I have accounts : - teddy/bear (normal user can create) - sun/solaris (granted DBA role) 2. I run the catexp.sql using sys account (just one error occur IMP_FULL_DATABASE confilct) 3. TEDDY created a table EMP with 7 records 4. I am using Sun account to export teddy table: inside my params.dat : FILE=/export/home/dba/myemp.dmp TABLES=(teddy.emp) ROWS=Y GRANTS=Y COMPRESS=Y 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-3: ORACLE error 1 encountered ORA-1: 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-3: ORACLE error 1 encountered ORA-1: 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: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Durinda.Jones INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
RE: No record in import help me please :..(
Hi, Just some thoughts - at step 7 did teddy commit after the delete - if not other users / sessions would still see the records as present. The import found some records so their must be an emp somewhere. So, try another step from your dba account (sun) of select object_name, object_type,owner from dba_objects where object_name = 'EMP'; Hope this might help Regards, Bruce -Original Message- Sent: Wednesday, 7 March 2001 14:10 To: Multiple recipients of list ORACLE-L 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. 1. In my Oracle I have accounts : - teddy/bear (normal user can create) - sun/solaris (granted DBA role) 2. I run the catexp.sql using sys account (just one error occur IMP_FULL_DATABASE confilct) 3. TEDDY created a table EMP with 7 records 4. I am using Sun account to export teddy table: inside my params.dat : FILE=/export/home/dba/myemp.dmp TABLES=(teddy.emp) ROWS=Y GRANTS=Y COMPRESS=Y 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-3: ORACLE error 1 encountered ORA-1: 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-3: ORACLE error 1 encountered ORA-1: 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: Reardon, Bruce (CALBBAY) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
RE: No record in import help me please :..(
I believe the SHOW=Y parameter is causing the problem. That does not do an import but rather lists the table/index/grants etc details held on the export.dmp REmove that parameter and try the fromuser to user parameters or the full =y parameter John -Original Message- [EMAIL PROTECTED] Sent: 05 March 2001 14:45 To: Multiple recipients of list ORACLE-L Hi guys, 1. In my Oracle I have accounts : - teddy/bear (normal user can create) - sun/solaris (granted DBA role) 2. I run the catexp.sql using sys account (just one error occur IMP_FULL_DATABASE confilct) 3. TEDDY created a table EMP with 7 records 4. I am using Sun account to export teddy table: inside my params.dat : FILE=/export/home/dba/myemp.dmp TABLES=(teddy.emp) ROWS=Y GRANTS=Y COMPRESS=Y 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 SHOW=Y IGNORE=N GRANTS=Y ROWS=Y DESTROY=Y COMMIT=Y I import imp sun/solaris parfile=imp_params.dat 9. the messeges that I got : ... ... .skipping table "EMP" ... ... ... ... Import terminated successfully without warnings. 10. When teddy select * from emp; 0 rows selected Can someone help me please... please ??? :( -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Hallas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
RE: No record in import help me please :..(
Set IGNORE=Y, SHOW=N in your import parameters. The table already exists, so you need to ignore errors, otherwise it won't import the rows. SHOW=Y will only list the contents of the export file, so it needs to be set to N (or not set it at all) so the rows will be imported. I would use care using the DESTROY=Y parameter. This could create a serious problem if you were to use it in a full import. Durinda -Original Message- Sent: Monday, March 05, 2001 8:45 AM To: Multiple recipients of list ORACLE-L Hi guys, 1. In my Oracle I have accounts : - teddy/bear (normal user can create) - sun/solaris (granted DBA role) 2. I run the catexp.sql using sys account (just one error occur IMP_FULL_DATABASE confilct) 3. TEDDY created a table EMP with 7 records 4. I am using Sun account to export teddy table: inside my params.dat : FILE=/export/home/dba/myemp.dmp TABLES=(teddy.emp) ROWS=Y GRANTS=Y COMPRESS=Y 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 SHOW=Y IGNORE=N GRANTS=Y ROWS=Y DESTROY=Y COMMIT=Y I import imp sun/solaris parfile=imp_params.dat 9. the messeges that I got : ... ... .skipping table "EMP" ... ... ... ... Import terminated successfully without warnings. 10. When teddy select * from emp; 0 rows selected Can someone help me please... please ??? :( -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Durinda.Jones INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
RE: No record in import help me please :..(
Title: RE: No record in import help me please :..( take out SHOW=Y it does just that: only SHOWs what it would do, does NOT do it. :-) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, March 05, 2001 9:45 AM To: Multiple recipients of list ORACLE-L Subject: No record in import help me please :..( Hi guys, 1. In my Oracle I have accounts : - teddy/bear (normal user can create) - sun/solaris (granted DBA role) 2. I run the catexp.sql using sys account (just one error occur IMP_FULL_DATABASE confilct) 3. TEDDY created a table EMP with 7 records 4. I am using Sun account to export teddy table: inside my params.dat : FILE=/export/home/dba/myemp.dmp TABLES=(teddy.emp) ROWS=Y GRANTS=Y COMPRESS=Y 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 SHOW=Y IGNORE=N GRANTS=Y ROWS=Y DESTROY=Y COMMIT=Y I import imp sun/solaris parfile=imp_params.dat 9. the messeges that I got : ... ... .skipping table EMP ... ... ... ... Import terminated successfully without warnings. 10. When teddy select * from emp; 0 rows selected Can someone help me please... please ??? :( -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
Re: No record in import help me please :..(
You need to add FROMUSER=TEDDY TOUSER=TEDDY to your parameter file and try again. [EMAIL PROTECTED] wrote: Hi guys, 1. In my Oracle I have accounts : - teddy/bear (normal user can create) - sun/solaris (granted DBA role) 2. I run the catexp.sql using sys account (just one error occur IMP_FULL_DATABASE confilct) 3. TEDDY created a table EMP with 7 records 4. I am using Sun account to export teddy table: inside my params.dat : FILE=/export/home/dba/myemp.dmp TABLES=(teddy.emp) ROWS=Y GRANTS=Y COMPRESS=Y 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 SHOW=Y IGNORE=N GRANTS=Y ROWS=Y DESTROY=Y COMMIT=Y I import imp sun/solaris parfile=imp_params.dat 9. the messeges that I got : ... ... .skipping table "EMP" ... ... ... ... Import terminated successfully without warnings. 10. When teddy select * from emp; 0 rows selected Can someone help me please... please ??? :( -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). begin:vcard n:Jerman;Don tel;work:919.508.1886 x-mozilla-html:TRUE org:Database Management Service,Information Technology version:2.1 email;internet:[EMAIL PROTECTED] title:Database Administrator adr;quoted-printable:;;Database Management Service,Information Technology=0D=0A104 Fayetteville Street Mall;Raleigh;NC;27699-1521;USA x-mozilla-cpt:;-9536 fn:Don Jerman end:vcard
Re: No record in import help me please :..(
Use the TABLES=(teddy.emp) and FROMUSER=teddy, TOUSER=sun parameters in you import parfile. This should do it. Ruth - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Monday, March 05, 2001 9:45 AM Hi guys, 1. In my Oracle I have accounts : - teddy/bear (normal user can create) - sun/solaris (granted DBA role) 2. I run the catexp.sql using sys account (just one error occur IMP_FULL_DATABASE confilct) 3. TEDDY created a table EMP with 7 records 4. I am using Sun account to export teddy table: inside my params.dat : FILE=/export/home/dba/myemp.dmp TABLES=(teddy.emp) ROWS=Y GRANTS=Y COMPRESS=Y 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 SHOW=Y IGNORE=N GRANTS=Y ROWS=Y DESTROY=Y COMMIT=Y I import imp sun/solaris parfile=imp_params.dat 9. the messeges that I got : ... ... .skipping table "EMP" ... ... ... ... Import terminated successfully without warnings. 10. When teddy select * from emp; 0 rows selected Can someone help me please... please ??? :( -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
RE: No record in import help me please :..(
Yeah, Its simple the two paramets giving you trouble!! show=y (it won't import any thing, It just show you it can work or not!!) destroy=y(Once you imported it, It will destroy the data of that copy) That is reason you can see the skipping...due to show=y Raghu. From: "John Hallas" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: No record in import help me please :..( Date: Mon, 05 Mar 2001 08:10:21 -0800 I believe the SHOW=Y parameter is causing the problem. That does not do an import but rather lists the table/index/grants etc details held on the export.dmp REmove that parameter and try the fromuser to user parameters or the full =y parameter John -Original Message- [EMAIL PROTECTED] Sent: 05 March 2001 14:45 To: Multiple recipients of list ORACLE-L Hi guys, 1. In my Oracle I have accounts : - teddy/bear (normal user can create) - sun/solaris (granted DBA role) 2. I run the catexp.sql using sys account (just one error occur IMP_FULL_DATABASE confilct) 3. TEDDY created a table EMP with 7 records 4. I am using Sun account to export teddy table: inside my params.dat : FILE=/export/home/dba/myemp.dmp TABLES=(teddy.emp) ROWS=Y GRANTS=Y COMPRESS=Y 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 SHOW=Y IGNORE=N GRANTS=Y ROWS=Y DESTROY=Y COMMIT=Y I import imp sun/solaris parfile=imp_params.dat 9. the messeges that I got : ... ... .skipping table "EMP" ... ... ... ... Import terminated successfully without warnings. 10. When teddy select * from emp; 0 rows selected Can someone help me please... please ??? :( -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Hallas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
RE: No record in import help me please :..(
When you use show=y, you're just listing the tables in the dump file. Either set this to N, or leave it out of your parm file. (N is the default) imp help=y will also tell you this. Hope that helps Patrick Prince [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Monday, March 05, 2001 8:45 AM To: Multiple recipients of list ORACLE-L Subject: No record in import help me please :..( Hi guys, 1. In my Oracle I have accounts : - teddy/bear (normal user can create) - sun/solaris (granted DBA role) 2. I run the catexp.sql using sys account (just one error occur IMP_FULL_DATABASE confilct) 3. TEDDY created a table EMP with 7 records 4. I am using Sun account to export teddy table: inside my params.dat : FILE=/export/home/dba/myemp.dmp TABLES=(teddy.emp) ROWS=Y GRANTS=Y COMPRESS=Y 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 SHOW=Y IGNORE=N GRANTS=Y ROWS=Y DESTROY=Y COMMIT=Y I import imp sun/solaris parfile=imp_params.dat 9. the messeges that I got : ... ... .skipping table "EMP" ... ... ... ... Import terminated successfully without warnings. 10. When teddy select * from emp; 0 rows selected Can someone help me please... please ??? :( -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: PRINCE, PATRICK W. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
RE: No record in import help me please :..(
Set IGNORE=Y, SHOW=N in your import parameters. The table already exists, so you need to ignore errors, otherwise it won't import the rows. SHOW=Y will only list the contents of the export file, so it needs to be set to N (or not set it at all) so the rows will be imported. Use the FROMUSER/TOUSER parameters if you are wanting to change the owner of the table. If you still want TEDDY to own the table, you don't need to use FROMUSER/TOUSER. The SUN user has DBA privilege, which will allow it to change to the TEDDY user and import the table. I would use care using the DESTROY=Y parameter. This could create a serious problem if you were to use it in a full import. This overwrites existing datafiles. I seldom use it in day-to-day operations. Durinda -Original Message- Sent: Monday, March 05, 2001 8:45 AM To: Multiple recipients of list ORACLE-L Hi guys, 1. In my Oracle I have accounts : - teddy/bear (normal user can create) - sun/solaris (granted DBA role) 2. I run the catexp.sql using sys account (just one error occur IMP_FULL_DATABASE confilct) 3. TEDDY created a table EMP with 7 records 4. I am using Sun account to export teddy table: inside my params.dat : FILE=/export/home/dba/myemp.dmp TABLES=(teddy.emp) ROWS=Y GRANTS=Y COMPRESS=Y 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 SHOW=Y IGNORE=N GRANTS=Y ROWS=Y DESTROY=Y COMMIT=Y I import imp sun/solaris parfile=imp_params.dat 9. the messeges that I got : ... ... .skipping table "EMP" ... ... ... ... Import terminated successfully without warnings. 10. When teddy select * from emp; 0 rows selected Can someone help me please... please ??? :( -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Durinda.Jones INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
Re: No record in import help me please :..(
Try using FROMUSER/TOUSER when importing. HTP. Gunawan Yuwono --- [EMAIL PROTECTED] wrote: Hi guys, 1. In my Oracle I have accounts : - teddy/bear (normal user can create) - sun/solaris (granted DBA role) 2. I run the catexp.sql using sys account (just one error occur IMP_FULL_DATABASE confilct) 3. TEDDY created a table EMP with 7 records 4. I am using Sun account to export teddy table: inside my params.dat : FILE=/export/home/dba/myemp.dmp TABLES=(teddy.emp) ROWS=Y GRANTS=Y COMPRESS=Y 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 SHOW=Y IGNORE=N GRANTS=Y ROWS=Y DESTROY=Y COMMIT=Y I import imp sun/solaris parfile=imp_params.dat 9. the messeges that I got : ... ... .skipping table "EMP" ... ... ... ... Import terminated successfully without warnings. 10. When teddy select * from emp; 0 rows selected Can someone help me please... please ??? :( -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gunawan Yuwono INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).