Not my type- copying user defined types.- HELP!
From: Howard Latham <howard.latham_at_gmail.com>
Date: Tue, 18 Nov 2008 10:33:16 +0000
Message-ID: <713d96d10811180233k56040d9cgf2d12b61c31e5c80@mail.gmail.com>
Date: Tue, 18 Nov 2008 10:33:16 +0000
Message-ID: <713d96d10811180233k56040d9cgf2d12b61c31e5c80@mail.gmail.com>
Version 10g
I am trying to copy 5 tables with user defined types from one schema to
another.
I have used export.
ON running the import first I got an error saying the OID was already in use
so the type couldn't be created
Then I created the types manually in the new schema. NOW import says the
OIDs don't match
Any idea how I can copy one schema to another with user defined types?
--
Howard A. Latham
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Nov 18 2008 - 04:33:16 CST