Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: No record in import help me please :..<(

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

From: Durinda.Jones <Durinda.Jones_at_yellowcorp.com>
Date: Mon, 05 Mar 2001 12:06:56 -0800
Message-ID: <F001.002C3D4D.20010305085615@fatcity.com>

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).
Received on Mon Mar 05 2001 - 14:06:56 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US