Hi,
You are missing an import parameter at step 8.
either
FULL=Y
or
FROMUSER=TEDDY
Should fix it.
Regards
Garry
> -----Original Message-----
> From: sinardyxing_at_bcsis.com [mailto:sinardyxing_at_bcsis.com]
> Sent: 05 March 2001 14:45
> 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 ??? :<(
++++++++++++++++++++++++++++++++++++
All internet traffic to this site is
automatically scanned for viruses
and vandals.
++++++++++++++++++++++++++++++++++++
Received on Mon Mar 05 2001 - 09:32:30 CST