Try using FROMUSER/TOUSER when importing.
HTP.
Gunawan Yuwono
- 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).
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: gyuwono_at_yahoo.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 - 14:27:46 CST
