Import Problem

I am running Oracle 8.1.7

I took the export of one of the user having 40 objects having data.

When I am importing to the other user or same user, there is a problem.I am able to import the objects those doesnot contains object types.

Those tables contains object types, the import is ignoring.

Hi, 30th Nov 2001 15:23 hrs Mumbai

The Problem is OID should be unique in the DB.

Since already if the same Object identifier for the type is existing you will have problem.

Even if you try to import to the other user you cannot.

Cheers

Padmam

I know that there is a problem with OID.

I have the Export dump file of Application Schema along with bunch of Data.
I want to Import all the Schema along with Data in to the New User. I am able to Import all the tables except those tables does not contain Object types. Even If I can Import with the same username in different database, its fine for me.

There is a option to ignore the object identifier called TOID_NOVALIDATE.

I try different ways to use it. But did not work. I am looking for solution.


[Edited by venudba on 12-03-2001 at 12:06 AM]

I am waiting for Solution

Hi, 30th Nov 2001 18:51 hrs Mumbai

Good then you should have mentioned what was the error reported .

I.e ORA number.

Since if you try to import in another DB you will not have problem at all.

Try to create a user in another db and try to import it- and let me know the same in this thread

Note:

In the first Article you have told that a particular Schema data alone(40 Objects Inc object types) is exported .

In second article you have mentioned All the Schemas(you mean one user or Multiple users)-

Then you have mentioned you are able to export all the tables except those tables which doesnt have object types

Let me know whether your are trying to Import or Export you have problem or both problems you have

So kindly clear my doubts along with the next follow up.

Cheers

Padmam


[Edited by padmam on 11-30-2001 at 08:36 AM]

I corrected the secons article. Please go through once again.

I will reframe my problem. I have one Payrole schema which contains around 40 objects(tables) with the username test.
In that one table I am using object type.

I have the expdump of the test schema(I took from the client place). I created the username as test. And I imported the dump file in to user test. The Import dumped all the tables and data except those doesnot contain object types.

Here I am including the Part of the Error Message

IMP-00017: following statement failed with ORACLE error 2304:
"CREATE TYPE "ADDRESS_TY" TIMESTAMP '2001-11-15:12:51:08' OID '1808F7F608E64"
"D53A3AD993BC56CC22B' "
" AS OBJECT ("
" TYPE_NO NUMBER(3),"
" LINE1 VARCHAR2(40),"
" LINE2 VARCHAR2(40),"
" LANDMARK VARCHAR2(40),"
" CITY VARCHAR2(30),"
" STATE VARCHAR2(30),"
" COUNTRY VARCHAR2(25),"
" ZIP VARCHAR2(10),"
" PHONE1 VARCHAR2(15),"
" PHONE2 VARCHAR2(15),"
" FAX VARCHAR2(15),"
" EMAIL VARCHAR2(40),"
" URL VARCHAR2(50));"
IMP-00003: ORACLE error 2304 encountered
ORA-02304: invalid object identifier literal
IMP-00017: following statement failed with ORACLE error 2304:
"CREATE TYPE "ADDRESS_VA" TIMESTAMP '2001-11-15:12:51:09' OID '2A0D45FFA9884"
"00DBA7695BBD767203C' "
" AS VARRAY(10) OF ADDRESS_TY;"
IMP-00003: ORACLE error 2304 encountered
ORA-02304: invalid object identifier literal
IMP-00017: following statement failed with ORACLE error 2304:
"CREATE TYPE "ROLE_TY" TIMESTAMP '2001-11-15:12:51:09' OID '126485955D9E4FAA"
"98D6441D4A5E0DE5' "
" AS OBJECT"
"(ROLE_NO NUMBER(3),"
" IND_CD VARCHAR2(2));"
IMP-00003: ORACLE error 2304 encountered
ORA-02304: invalid object identifier literal
IMP-00017: following statement failed with ORACLE error 2304:
"CREATE TYPE "ROLE_VA" TIMESTAMP '2001-11-15:12:51:09' OID '280BB27260204AD0"
"953C46B60B3D020E' "
" AS VARRAY(10) OF ROLE_TY;"
IMP-00003: ORACLE error 2304 encountered
ORA-02304: invalid object identifier literal

I have not the perfect solution but you can try for this in case of urgency

You just create the structure of that user and then try to import the data.

hope this will work for the time beeing.

Hi Shilendra, 3rd Dec 2001 16:49 hrs Mumbai

I think you cannot create a same structure and then import the data alone that wont work out.

Any how venudba i will try it out your problem.I have also sent mail to 2 persons who had simillar problem as per this Link.

http://www.alchemedia.co.uk/cimtech/...sages7/20.html

If any mail communication from them i will post solution across.

OK you have done whole exp of Test Schema from some client place db.

Then you have imported in another DB server right?

It should not be a Problem at all.

Since in one of my Railway Projects recently i had same problem but in client place we where later successful in importing the full schema after dropping the previous same schema was dropped.We recreated the same username and imported it.The schema also had nested table and object types etc and around 100 tables.

Hope and wait for a Good solution.

Cheers

Padmam

Hi, 3rd dec 2001 19:58 hrs Mumbai

I got the reply from Mr.Abu.

The solution is as follows.

====
Hi Padma,

What we have done regarding this is we have created a user where all types are
there suppose we call the user,
OraTypes. Now whenever we have to use these types in another user called,OraUse.
we refer to OraTypes.TypeName.

Whereever you need OraUse user, you need to export both the user OraUse and
OraTypes. It will not create any problems.

I hope I was able to answer your query. This is the best way we have
implemented. Do mail me if you face any other problem.

Thanks and Regards,
Abu.

===
Thanks Abu

Cheers

Padmam


[Edited by padmam on 12-03-2001 at 09:34 AM]

I did not get what Abu is saying.

Can you explain in detail.

How to use the parameter TOID_NOVALIDATE