Import Problem
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 13

Thread: Import Problem

  1. #1
    Join Date
    Aug 2001
    Location
    Hyderabad, India
    Posts
    30
    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.

    Venkateshwarlu.K

  2. #2
    Join Date
    Mar 2000
    Location
    Chennai.Tamilnadu.India.
    Posts
    658

    Solution

    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
    Attitude:Attack every problem with enthusiasam ...as if your survival depends upon it

  3. #3
    Join Date
    Aug 2001
    Location
    Hyderabad, India
    Posts
    30

    Smile Import - Invalid object identifier literal

    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]
    Venkateshwarlu.K

  4. #4
    Join Date
    Aug 2001
    Location
    Hyderabad, India
    Posts
    30

    Smile

    I am waiting for Solution
    Venkateshwarlu.K

  5. #5
    Join Date
    Mar 2000
    Location
    Chennai.Tamilnadu.India.
    Posts
    658

    follow up

    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]
    Attitude:Attack every problem with enthusiasam ...as if your survival depends upon it

  6. #6
    Join Date
    Aug 2001
    Location
    Hyderabad, India
    Posts
    30

    Smile

    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

    Venkateshwarlu.K

  7. #7
    Join Date
    Sep 2000
    Posts
    305
    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.


  8. #8
    Join Date
    Mar 2000
    Location
    Chennai.Tamilnadu.India.
    Posts
    658

    Lead

    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
    Attitude:Attack every problem with enthusiasam ...as if your survival depends upon it

  9. #9
    Join Date
    Mar 2000
    Location
    Chennai.Tamilnadu.India.
    Posts
    658

    Re: Lead

    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]
    Attitude:Attack every problem with enthusiasam ...as if your survival depends upon it

  10. #10
    Join Date
    Aug 2001
    Location
    Hyderabad, India
    Posts
    30

    Smile


    I did not get what Abu is saying.

    Can you explain in detail.

    How to use the parameter TOID_NOVALIDATE
    Venkateshwarlu.K

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width