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

From: Reardon, Bruce (CALBBAY) <Bruce.Reardon_at_comalco.riotinto.com.au>
Date: Tue, 06 Mar 2001 20:05:49 -0800
Message-ID: <F001.002C5620.20010306192545@fatcity.com>

Hi,

Just some thoughts - at step 7 did teddy commit after the delete - if not other users / sessions would still see the records as present.

The import found some records so their must be an emp somewhere. So, try another step from your dba account (sun) of

select object_name, object_type,owner from dba_objects where object_name = 'EMP';

Hope this might help
Regards,
Bruce

-----Original Message-----
Sent: Wednesday, 7 March 2001 14:10
To: Multiple recipients of list ORACLE-L

Hi guys,

Thank You

Durinda.Jones
Don.Jerman
Dave Weber
Gillies Garry
Raghu Kota
Ruth Gramolini
Mohan, Ross
And to all readers..

What I am doing now is to try write my own backup script and test it in my stand alone Sun Ultra 10
with Solaris 2.7 and Oracle 8.1.6
Thank you guys, for giving me solution, "SHOW = N" and "DESTROY=N" it is work 7 records was imported into the table.

Now I try to import my previous myemp.dmp after teddy "drop table emp" my import parameters as at point 8.

In my Oracle I have accounts : - teddy/bear (normal user can create)
- sun/solaris (granted DBA role)
I run the catexp.sql using sys account (just one error occur IMP_FULL_DATABASE confilct)
TEDDY created a table EMP with 7 records
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
                FROMUSER=TEDDY
                TOUSER=TEDDY
                TABLES=(emp)
                IGNORE=Y                 -> because the table is not exists
??
                GRANTS=Y
                ROWS=Y
                COMMIT=Y

        I import
                imp sun/solaris parfile=imp_params.dat

9. the messeges that I got :
                . import TEDDY's Object
                . . importing table                     "EMP"
                IMP-00019: row rejected due to ORACLE error 1
                IMP-00003: ORACLE error 1 encountered
                ORA-00001: unique constraint (TEDDY.EMP_PK) violated
                Column 1  11
                Column 2  Don
                Column 3  McIntyre
                Column 4  03-Jun-1972:00:00:00
                IMP-00019: row rejected due to ORACLE error 1
                IMP-00003: ORACLE error 1 encountered
                ORA-00001: unique constraint (TEDDY.EMP_PK) violated
                Column 1  12
                Column 2  Micheal
                Column 3  Jackson
                Column 4  25-Jun-1988:00:00:00
                ....
                ....


                Import terminated successfully with warnings.

10. When teddy select * from emp;
                ERROR at line 1
                ORA-00942: table or view does not exist

Can someone help me please... please ??? :<(
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Reardon, Bruce (CALBBAY)
INET: Bruce.Reardon_at_comalco.riotinto.com.au

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 Tue Mar 06 2001 - 22:05:49 CST