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

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