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

take out

SHOW=Y it does just that:  only SHOWs what it would do, does NOT do it.

:-)

-----Original Message-----
From: sinardyxing_at_bcsis.com [mailto:sinardyxing_at_bcsis.com] Sent: Monday, March 05, 2001 9:45 AM
To: Multiple recipients of list ORACLE-L Subject: No record in import help me please :..<(

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

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