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

Thread: Export

  1. #1
    Join Date
    May 2002
    Posts
    232

    Red face

    Helooo,friends i am asking this question since one week ,but no won't give reply,again i am posting,any expert can help me,it is very most crucial one for me.
    Any cost tomorrow i need to migrate my data.

    Full details
    I have olddatabase name abc(oracle8i 8.1.7)
    this database contains details about mobile users.

    Now we create the newdatabase xyz(oracle9i)
    This newdb contains olddb(abc)tables as well as we added some new columns to the tables.

    Now my problem is before removing the Olddb,entire data might be export into new db(oracle9i).
    I was created newdb on sunsolaris.
    Now i need to dump the olddata into newdb.
    how?
    i hope so many experts,
    plss help me
    thanks
    kavitha


    kavitha

  2. #2
    Join Date
    Oct 2000
    Location
    Charlotte, USA
    Posts
    330
    Hi,
    you can export and import.
    The problem here is the table in which you are importing differ from exported tables..(Structure wise)...import may fail.
    So options are if the tables are empty in newdb...
    then drop them and import the tables from olddb, later add the additional columns.
    Hi Gurus,If I am wrong please correct me.
    Thanks.
    Thanigaivasan.

  3. #3
    Join Date
    Dec 2001
    Location
    SAN FRANCISCO, CA
    Posts
    306
    i think U need to take a full export backup with option full=y.

    Create the database manually.
    Also create the tablespace manually. The tablespace name should exact match with the new db in 9i.

    Then u can run the import utility.

    As long as u have full export backup , import will create users for u.

    Gurus please correct me if i am wrong.

    Pravin
    Eat , Drink & Enjoy life -

    pravin_kini@hotmail.com

  4. #4
    Join Date
    May 2002
    Posts
    232
    Hiii,thanks
    But my olddatabase 8i and
    new one 9i.
    So ,any impact?
    thanks
    kavitha
    kavitha

  5. #5
    Join Date
    Oct 2000
    Location
    Charlotte, USA
    Posts
    330
    export old version 8i ------->imp new version 9i....okay
    export version 9i------------->imp version 8i .....No
    Thanks.
    Thanigaivasan.

  6. #6
    Join Date
    May 2002
    Posts
    232
    Hiii,Thanigaivasan thanks
    Already i have newdatabase,but i did not add any new tables into new db.
    So shall change any configuration in newdb,regarding tablespacenames,datafilenames etc
    soon reply
    thanks
    kavitha

  7. #7
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    You can also use COPY command depending upon no of table you wanted to export and probably you can script 'em if there more tables to refresh data. That way you don't need to drop the columns you have changed. You justify which is more comfortable and consume less time. See the following Link.

    http://home.fms.indiana.edu/users/cs...6/ch63.htm#307
    Reddy,Sam

  8. #8
    Join Date
    May 2002
    Posts
    232
    hii,sreddy i was tested copy method ,but it applicable only where two tables have same number of columns.
    i mean from olddb table to new db table.
    thanks
    kavitha

  9. #9
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    May be true. My mistake. I have not tested COPY command on tables with different structure. This command runs is pretty fast depending upon the array size,commit size you define. You can replace the tables using copy command.

    Its all depends up on how big your tables and how much time you have... I use this command regularly to refresh data from PROD to QA and DEVT.
    Reddy,Sam

  10. #10
    Join Date
    Dec 2001
    Location
    SAN FRANCISCO, CA
    Posts
    306
    kavithared,
    boss u need to read the oracle docs properly.
    It helps a lot !!!

    --pravin
    Eat , Drink & Enjoy life -

    pravin_kini@hotmail.com

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