Re: No record in import help me please :..<(

You need to add

FROMUSER=TEDDY
TOUSER=TEDDY to your parameter file and try again.

sinardyxing_at_bcsis.com 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: 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).
Received on Mon Mar 05 2001 - 13:35:20 CST