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).