Results 1 to 7 of 7
  1. #1
    Join Date
    Apr 2011
    Posts
    11

    Unanswered: Need Help for database issue..Super Urgent and Super headache..

    Hii...im new in db...
    i have a million record in old system and im try to transfer database to new system using sqlldr...but the problem is,in old system have a separated database like DB_A,DB_B,DB_C and got 10 different database transaction and want to transfer to new system means from 10 merge to 1 database,and another problem if got one customer register into DB_A and also register to DB_B how i can make sure this customer not to mix up or duplicate..

    Can multiple table with different database want to merge into 1 database?

    Can anyone help me find out about this problem..plss...

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    post COMPLETE results from SQL below

    SELECT * FROM V$VERSION;
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Apr 2011
    Posts
    11
    Thanks for the quick replay..appreciate so much..

    Here as your requested...

    BANNER
    Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bi
    PL/SQL Release 10.2.0.2.0 - Production
    "CORE 10.2.0.2.0 Production"
    TNS for HPUX: Version 10.2.0.2.0 - Production
    NLSRTL Version 10.2.0.2.0 - Production

  4. #4
    Join Date
    Mar 2002
    Location
    Reading, UK
    Posts
    1,137
    Do you mean tables when you say "database". If so import them into ten different tables in Oracle. Then write a query to select from all 10 tables, dedup it (group by is one way of doing it, another way is row_number()) and insert it into your new unified table.

    I suspect the difficult bit is deduping as how do you know which record has the most upto date details.

    Alan

  5. #5
    Join Date
    Apr 2011
    Posts
    11
    Dear Alan,

    Thanks for the responding..Actually im want to transfer database.Means i have a database A with so many table,also database B,C and so on..and all database have a same data type at table also same at new database i want to transfer.
    The problem is,each database have a million record transaction and the issue is the customer also can register at database A and database B.
    it is possible i transfer using sqlldr?it is i have do a merge or staging?

  6. #6
    Join Date
    Mar 2002
    Location
    Reading, UK
    Posts
    1,137
    Create ten users in your Oracle database and then import each "database" into a user. Once they are all loaded create another user which will be your new combined schema. Give it privs to see all the tables in the other ten users. Then you need to write a query which will pull in the data from the 10 users, dedup it and then insert it into the new combined schema.

    Alan

  7. #7
    Join Date
    Apr 2011
    Posts
    11
    Alan...appreciate so much with your feedback..
    it is possible?for your information,this database not link for another database,separated.sorry with my stupid question..im just wanna learn more even im studying alone,im need a guide...

    another one,it is possible if i create 1 procedure to call multiple table..

Posting Permissions

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