| 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 :..<(
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" <john.hallas_at_mail.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>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-----
>sinardyxing_at_bcsis.com
>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: sinardyxing_at_bcsis.com
>
>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: 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).
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: John Hallas
> INET: john.hallas_at_mail.com
>
>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: 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).
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: raghukota_at_hotmail.com 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: 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 Mon Mar 05 2001 - 13:53:41 CST
 |
 |