Not my type- copying user defined types.- HELP!

  • From: "Howard Latham" <howard.latham@xxxxxxxxx>
  • To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 18 Nov 2008 10:33:16 +0000

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

Other related posts: