-
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
-
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.
-
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
-
Hiii,thanks
But my olddatabase 8i and
new one 9i.
So ,any impact?
thanks
kavitha
kavitha
-
export old version 8i ------->imp new version 9i....okay
export version 9i------------->imp version 8i .....No
Thanks.
Thanigaivasan.
-
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
-
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
-
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
-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|