Topic: Backup & Recovery >> Complete Oracle Database migration
|
Disclaimer: The purpose of all dbapool forums including OCP and Other Oracle Certification forums is to help each other with specific issues but not to share dump and copyrighted exam content, materials or intellectual property.
You may review the entire Oracle Certification Program Candidate Agreement online Here.
|
|
|
|
| Title: Complete Oracle Database migration |
| Suresh |
Posted: Jul 19, 2006 04:07:24 AM |
Total Post: 2
Joined: Jul, 2006
|
I tried to migrate the complete database from one compiuter to another.
It's on oracle 9i and need to imported on same oracle 9i,
I used exp utility to export it.
e.g exp system/<pass.> full=y file=c:\mydb.dmp
There is no problem while doing export, it prepares mydb.dmp on given location.
I have kept mydb.dmp in server and used imp utility to export.
e.g imp system<pass.> full=y
It has importyed successfully.
I got confusion with imp utility to get same database in destination computer.
I have found that there is mapping parameter with Oracle datapump in
10g. Now, in oracle 9i, didn't get the same database inside oradata
(Where the database resides) folder at server after doing import.
What additional work I should do to get exported same complete
database in oradata folder in oracle so that I can open it through
startup after changing ORACLE_SID, os environment variable in
destination computer.
I guess you came to know the scenirio, could you please guide me what
additional I should to get same exported database in destination using
imp utility.
I tried and even explore on net but not got the satisfied solution.
Suresh Gautam
|
|
|
 Vigyan |
| Posted: Jul 19, 2006 10:06:10 PM |  |
|
Total Post: 386
Joined: May, 2001
|
Create new tablespaces the way you want data files and then import the data.
Hope it helps.
Vigyan
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
|
|
|
|
Forum Rules & Description
Who Can Read The Forum? Any registered user or guest
Who Can Post New Topics? Any registered user
Who Can Post Replies? Any registered user
|
| |
Get FREE Magazines
|
Top 10 Forum User
|
| Murtuja Khokhar | 857 |
| Mohammed Taj | 746 |
| positive fanatic | 483 |
| Jayanta Sur | 479 |
| Vigyan Kaushik | 386 |
| Gopu Gopi | 335 |
| Gitesh Trivedi | 322 |
| Vinoth Kumar | 264 |
| neeraj sharma | 258 |
| Ramesh Jois | 246 |
|
|
