OraFAQ Forum: Server Utilities » Type object not imported during schema import

Home » RDBMS Server » Server Utilities » Type object not imported during schema import

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Type object not imported during schema import [message #204520]

Tue, 21 November 2006 02:51

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

Report message to a moderator

Re: Type object not imported during schema import [message #204521 is a reply to message #204520]

Tue, 21 November 2006 02:54

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Hi Mohammed,

Oracle Version ?
OS platform ?

regards
Taj.

Report message to a moderator

Re: Type object not imported during schema import [message #204522 is a reply to message #204521]

Tue, 21 November 2006 02:59

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

Report message to a moderator

Re: Type object not imported during schema import [message #204536 is a reply to message #204521]

Tue, 21 November 2006 03:24

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

Report message to a moderator

Re: Type object not imported during schema import [message #204569 is a reply to message #204536]

Tue, 21 November 2006 05:27

Mahesh Rajendran
Messages: 10708
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

Report message to a moderator

Re: Type object not imported during schema import [message #204602 is a reply to message #204569]

Tue, 21 November 2006 06:25

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

Report message to a moderator

Re: Type object not imported during schema import [message #204627 is a reply to message #204602]

Tue, 21 November 2006 07:44

Mahesh Rajendran
Messages: 10708
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.

Report message to a moderator

Re: Type object not imported during schema import [message #204628 is a reply to message #204627]

Tue, 21 November 2006 07:44

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Or use any gui tools.
Oracle's free tool SQL Developer can extract the DDL.

Report message to a moderator

Previous Topic:	Free Text Unload utility, OCI based
Next Topic:	SQL LOADER ORA 01772

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Dec 26 00:17:11 CST 2024