Re: export/import object types

From: Richard Ji <rji_at_exenet.com>
Date: Mon, 23 Jul 2001 07:40:57 -0700
Message-ID: <F001.00351A8F.20010723072201@fatcity.com>

Thanks for the info. I looked at it, it's very informative.

>>> abardeen1_at_yahoo.com 07/22/01 12:17PM >>> Richard,

This is an issue with TYPE objects as the TOID (type object ID) is exported (see the Utilities manual). Also see Note: 1066139.6 "IMP-17 IMP-3 ORA-2304 IMP-63 FROMUSER/TOUSER Import of Table With Object Column"

HTH,

• Anita
  • Richard Ji <rji_at_exenet.com> wrote:
    > Hi all,
    >
    > I wonder if anyone has seen this before.
    >
    > I export an user A, then import it into user B in a
    > different database
    > and everything is ok. Then I use the same export
    > file to import into
    > user C in the same database as user B and all the
    > "CREATE TYPE...."
    > failed because Oracle retains the object id in the
    > export file and when
    > importing into user C it tries to create them with
    > the same object id
    > and since user B already has it it failed. I had to
    > manually delete
    > the object id from the log and recreate it.
    >
    > It's not a huge problem since it's rare that I do
    > something like this.
    > But just wondering why would Oracle retain the
    > object id for TYPE?
    > It certainly didn't keep the same object id for
    > other objects like table, etc.
    >
    > Any thoughts?
    >
    > Richard Ji
    

    ---

Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: A. Bardeen
  INET: abardeen1_at_yahoo.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: Richard Ji
  INET: rji_at_exenet.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 Jul 23 2001 - 09:40:57 CDT