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

Set IGNORE=Y, SHOW=N in your import parameters. The table already exists, so you need to ignore errors, otherwise it won't import the rows. SHOW=Y will only list the contents of the export file, so it needs to be set to N (or not set it at all) so the rows will be imported. Use the FROMUSER/TOUSER parameters if you are wanting to change the owner of the table. If you still want TEDDY to own the table, you don't need to use FROMUSER/TOUSER. The SUN user has DBA privilege, which will allow it to change to the TEDDY user and import the table.

I would use care using the DESTROY=Y parameter. This could create a serious problem if you were to use it in a full import. This overwrites existing datafiles. I seldom use it in day-to-day operations.

Durinda
-----Original Message-----
Sent: Monday, March 05, 2001 8:45 AM
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: Durinda.Jones
  INET: Durinda.Jones_at_yellowcorp.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).