Home » RDBMS Server » Server Utilities » Type object not imported during schema import
Type object not imported during schema import [message #204520] Tue, 21 November 2006 02:51 Go to next message
dbasif
Messages: 35
Registered: March 2006
Location: Bangalore, India
Member

HI ,

i made a schema level export from one database and imported in to another database, but i am not able to see any type object which was present in the source schema., please help if there is any method to import type object also.

Regards
Asif
Re: Type object not imported during schema import [message #204521 is a reply to message #204520] Tue, 21 November 2006 02:54 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi Mohammed,

Oracle Version ?
OS platform ?



regards
Taj.
Re: Type object not imported during schema import [message #204522 is a reply to message #204521] Tue, 21 November 2006 02:59 Go to previous messageGo to next message
dbasif
Messages: 35
Registered: March 2006
Location: Bangalore, India
Member



source :9.2.0.5.0 / HP 11.11
destination :9.2.0.7.0 /HP 11.11
Re: Type object not imported during schema import [message #204536 is a reply to message #204521] Tue, 21 November 2006 03:24 Go to previous messageGo to next message
dbasif
Messages: 35
Registered: March 2006
Location: Bangalore, India
Member

Hi All,

some clue :--

While import i got the following error :-

ORA-02304: invalid object identifier literal
IMP-00017: following statement failed with ORACLE error 2304:
"CREATE TYPE "STRING_TABLE_TYPE" TIMESTAMP '2005-10-
06:10:52:58' OID '027814"
"B5B828292EE0440003BA7453BF' AS TABLE OF VARCHAR2
(2000);"

Regards
Asif
Re: Type object not imported during schema import [message #204569 is a reply to message #204536] Tue, 21 November 2006 05:27 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
A little search could always help.
http://www.orafaq.com/forum/m/165975/42800/?srch=OID#msg_165975
icon7.gif  Re: Type object not imported during schema import [message #204602 is a reply to message #204569] Tue, 21 November 2006 06:25 Go to previous messageGo to next message
dbasif
Messages: 35
Registered: March 2006
Location: Bangalore, India
Member

Thanx Mahesh,

it is working ,i extracted the ddl statement from the log for type definition but created with invalid status, any way i think this is the only solution.

if someone has another sol plz help, as i have to do manual edit on logfile,for around 100 types.

Regards
Asif

Re: Type object not imported during schema import [message #204627 is a reply to message #204602] Tue, 21 November 2006 07:44 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
It is quite simple to script this out.
Use DBMS_METADATA. search the forum for examples.
Re: Type object not imported during schema import [message #204628 is a reply to message #204627] Tue, 21 November 2006 07:44 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Or use any gui tools.
Oracle's free tool SQL Developer can extract the DDL.
Previous Topic: Free Text Unload utility, OCI based
Next Topic: SQL LOADER ORA 01772
Goto Forum:
  


Current Time: Fri Dec 02 16:36:17 CST 2016

Total time taken to generate the page: 0.14713 seconds