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: Problems with export/import

Re: Problems with export/import

From: <Winnie_Liu_at_infonet.com>
Date: Wed, 28 Mar 2001 10:28:20 -0800
Message-ID: <F001.002DA848.20010328103104@fatcity.com>

Maybe there are several things you want to check on your table in database B

  1. Do you have any trigger on that table?
  2. Do you have any foreign key constraints on that table?
  3. Is that table structure the same on 2 databases?

Winnie

"Helmut Daiminger" <hdaiminger_at_vivonet.com> on 03/28/2001 11:24:28 AM

Please respond to <hdaiminger_at_vivonet.com>

To: "Oracle DBA List \(Lazy DBA\) \(E-mail\)" <oracledba_at_quickdoc.co.uk>,

      "Oracle List \(Telelist\) \(E-mail\)" <ORACLE-L_at_fatcity.com> cc:

Hi!

I'm having weird problems with exporting/importing tables...

First I run an export on database A

About to export specified tables via Conventional Path ... Table(T) or Partition(T:P) to be exported: (RETURN to quit) > tbclocktimes

. . exporting table                   TBCLOCKTIMES       2929 rows exported

The exports terminates successfully without warnings.

Then I want to import that dump file into database B, but it fails:

. importing VIVOUSER's objects into VIVOUSER . . importing table "TBCLOCKTIMES"
IMP-00058: ORACLE error 1403 encountered ORA-01403: no data found

Any idea what's going wrong?

This is 8.1.6 on Win2k

Thanks,
Helmut



Think you know someone who can answer the above question? Forward it to them!
to unsubscribe, send a blank email to oracledba-unsubscribe_at_LAZYDBA.com to subscribe send a blank email to oracledba-subscribe_at_LAZYDBA.com Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com

--

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

Author:
  INET: Winnie_Liu_at_infonet.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 Wed Mar 28 2001 - 12:28:20 CST

Original text of this message

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